Mike Blezien writes:
> Hi all,
>
> trying to figure out the relationship of the mysql User and db tables. Now when
> a database is created and privileges are assigned to the new db, the db table is
> updated and the user table is updated, but in the privilege columns of the user
> table, all are set to 'N' but the appropriate privileges are set to 'Y' in the
> db table for that particular database.
>
> Is there something I'm missing or doing wrong??
>
>
> Mike(mickalo)Blezien
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
> Thunder Rain Internet Publishing
> Providing Internet Solutions that work!
> http://www.thunder-rain.com
> Tel: 1(225)686-2002
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Nope, you are not missing anything.
There are four level of privileges in MySQL:
- global
- database
- table
- column
It is important to know that privileges are OR'd not AND'd, so there
are no problems with your setup.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
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
