Re: DB getTables() and permissions, bug #5800
| From: | Leo Lutz | Date: | Thu, 27 Oct 2005 22:22:39 +0000 |
| Subject: | Re: DB getTables() and permissions, bug #5800 | ||
| References: | 1 2 3 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-40323@lists.php.net to get a copy of this message | ||
> Mysql and im assuming most other db's can actually do permissions down
> to the column level.
> -josh
Thanks, I was playing with MySQL 4 which I can't seem to revoke USAGE
on a table or column.
MySQL docs:
"Note: If you have no privileges for a table, the table does not show
up in the output from SHOW TABLES or mysqlshow db_name"
Since there isn't a way to get table names that a user doesn't have
access to in MySQL, it might be a good idea to replicate that behavior
for PostgreSQL.