mysql grant problem
| From: | Fai | Date: | Wed, 16 May 2001 17:39:57 +0000 |
| Subject: | mysql grant problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9367@lists.php.net to get a copy of this message | ||
When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by
"peter";
Then peter can only select the field of col_name_1 on the tbl_name_1 of
db_name_1.
However, when peter issue the query: DESC tbl_name_1; he can see all the
structure of that table. This makes that peter does not know which column he
can use.
This also is the case that the user still can see all the database in mysql
server when he
issues "show databases" even if he only has the right to use one database
althought we
can use the "--skip-show-database" command at the start up.
Does any body know how to solve these problems? Or this is mysql server's
restriction while
compare with Oracle or MSSQL?