Hello, all.

I'm having a little trouble with the TABLESTATISTICS table in MaxDB 
7.6.0.16.  If I select * from TABLESTATISTICS, I can see only tables whose 
schema matches the connected user.  Even if the connected user has 
permission to select from tables in another schema, the connected user still 
can't see those tables listed in TABLESTATISTICS.

The behavior becomes a problem when there are tables in a schema created by 
the CREATE SCHEMA statement, and the name of that schema doesn't match any 
actual user.  When that happens, you can't see the aforementioned tables 
listed in TABLESTATISTICS at all.

So, how do I get at the information that I would've pulled from 
TABLESTATISTICS?

Thanks,
Mark Thomas 




-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to