On Jan 19, 2007, at 2:13 PM, johnf wrote:
> Right. So if I can filter the schema to return only the tables
> along with the
> schemas based on the user - this will work right?
It depends on the backend and how it implements permissions. For
example, if you log on to the demo server using the webuser account,
you only see the webtest database; MySQL will not even let you know
that others may exist to which you don't have rights. Similarly, if
you only have rights to certain tables in a database, and issue a
SHOW TABLES command, it will only return tables to which you have
rights.
I would hope that if you are connected to a PostgreSQL database and
issue the equivalent to SHOW SCHEMAS, it would only return the ones
that you are supposed to be seeing.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
