Rhino wrote:
<snip>
Regardless of what appears in the Grant tables, do the permissions work the way you want them to if you give the privileges the way I suggested? I gave some privileges to a new userid yesterday (in MySQL) and found that the User table showed the userid but had all the grant columns set to N, even for the privileges I granted. Despite that the userid worked when I used it. I suspect that the Grant tables don't always reflect reality in MySQL....
The grant tables do reflect reality, if you know how to read them. Only GLOBAL privileges go in the mysql.user table. DB privileges go in the db and host tables, table privileges go in tables_priv, and column privileges go in columns_priv.
See the manual <http://dev.mysql.com/doc/mysql/en/Privileges.html> for the details.
Rhino
Michael
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
