On Tue, 15 Oct 2002, Alexander Burbello wrote:
>
> 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'?
Hi!
Well, testing that ought not to be too difficult. ;-) Just run a couple of
statements as those users and see what they can accomplish. MySQL states
pretty clearly when you don't have sufficient access to something.
Regards,
Iikka
******************************************
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland *
******************************************
---------------------------------------------------------------------
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
