OK two thinks to lookat 1. Use GRANTS as you will not have so much truble with them.... 2. Use "mysqlaccess" this will tell you if you have got the privileges right..
If a user can select in 'user' table then he can do so on all databases. (what ever is set in 'db') If a user can select in 'db' table then he can do so on that database (what ever is set in 'table_priv') Simon -----Original Message----- From: Alexander Burbello [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:49 To: [EMAIL PROTECTED] Subject: Privileges - Does Anybody knows how to answer to me? Hi, I read the book, but there is not explain about it. I would like to know when I give privileges to the user, in the table level, and after I give privileges in the database level. Do I replace the privileges? There are two tables ('db' and 'tables_priv') in mysql database. I gave privileges, for example, to the table 'tables_priv', I give only 'select' privilege to the table Tb01. But I give other privileges, now to the table 'db'. I gave 'insert', 'delete' and 'update' privileges to the database 'Test'. Now the user has privileges to: - 'select' the table 'Tb01' - ''insert', 'delete' and 'update' the database 'Test'. Right --------------------------------------------------------------- What can he do? Can he insert or delte on the table tb01? Can he select data in all the tables of the database 'Test'? Regards sql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
