At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote:
I just noticed that a restricted user to only one database can still
run "show databases;"
and see all the names of the databases in MySQL.
You would think that it would only return the databases that that
user is allowed to connect to.
Is there a way I can show only those databases that he has rights to
without giving him rights to the mysql database to use the db table?
Make sure that the user doesn't have any global privileges that apply
to databases. If the user has such a privilege, SHOW DATABASES will
display all databases. (To check this, look at the privilege columns
in the mysql.user table for the user's account record.)
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
