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
