[PHP-DB] mysql grant problem
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? -- 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]
Re: [PHP-DB] mysql grant problem?
On Sat, Mar 24, 2001 at 11:22:37PM +0800, Fai wrote: 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. Does any body know how to make peter only can see the column which he has right to use it when he issue DESC tbl_name_1. I'm not sure but I think this is a question that should have been posted to a Mysql list. [EMAIL PROTECTED] -- Jason Stechschulte [EMAIL PROTECTED] -- OOPS! You naughty creature! You didn't run Configure with sh! I will attempt to remedy the situation by running sh for you... -- Larry Wall in Configure from the perl distribution -- 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]
[PHP-DB] mysql grant problem?
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. Does any body know how to make peter only can see the column which he has right to use it when he issue DESC tbl_name_1. -- 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]