Ok, now I understand, the "global" would refer to the privileges set in the
mysql db user table then,..correct?? :) and the privileges set in the db table
are specific to that particular database. Sound right??
thanks
>>> 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??
>>On Mon, 30 Jul 2001 21:07:06 +0300, Sinisa Milivojevic <[EMAIL PROTECTED]> wrote:
>>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.
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
---------------------------------------------------------------------
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
