Harald Falkenberg wrote:
Hallo,
after creating a user via the grant command, I found that this new user
can see by the 'show database' command the mysql database although the
grant does not apply to it.
This new user can run the 'use mysql' command, but has no access to the
tables.
The db table only show access grants to non mysql databases.
What has went wrong here and how can I solve the problem?
mysql version 4.0.16.
regards
Harald
Hi Harald,
that is quite easy. Using the grant command sets the privileges in the
user table (which is one of the security tables).
read the info at:
http://dev.mysql.com/doc/mysql/en/privilege-system.html
to understand the privilege system in MySql.
you have to revoke all privileges in the user table and insert a record
into the db table where you can define the database you want the user to
be granted on.
Best Regards,
Danny Stolle
Netherlands
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
