David Bouw writes:
> Hi there..
>
> I am not understanding something how the mysql priviege system works:
>
> I want to do the following:
>
> Give a user access to all tables in an database (also tables which will be added in
>the future) except a
> few private tables like the mysql table itself
>
> This is the way I thought it should be done:
>
> Add a user: '%','username','password','Y',Y','Y','Y','Y','Y','N','N' etc//
> Then add the following to table db
>
> '%',mysql','username','N',N','N','N','N','N','N','N' etc//
>
> Run the Flush privileges command and try it..
>
> This doesn't work! Or I am missing something..
> When I think logically, I can maybe understand that the DB looks at the user table
>and sees that the uses has access to do everything and doesn't look further at de db
>table..
>
> Is this correct? What is then the solution to do what I described above..
>
> I looked at the manual, but I can't seem to figure out in what order the tables are
>checked..
> Does it stop looking further when he finds permission to do something or does it
>stop at the first 'N'...
>
>
> PS: I am not planning to use the above example, but it will help me understand how
>the privilege system works..
Hi!
You should not meddle with privilege tables directly.
You should use GRANT / REVOKE commands instead. Read the manual on the
subject.
Regards,
Sinisa
____ __ _____ _____ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____
^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^
/*/ \*\ Developers Team
---------------------------------------------------------------------
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