When we use grant as following:
GRANT select(col_name_1) on db_name_1.tbl_name_1 to peter identified by

Then peter can only select the field of col_name_1 on the tbl_name_1 of

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?

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to