On 10/17/2004 7:12 AM, Michael J. Pawlowsky <[EMAIL PROTECTED]> wrote:
> All priviliges for that user in mysql.user are set to N. > I know this is hard to read but here are the outputs from user and db. [snip] > Paul DuBois wrote: > >> 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.) Your grant tables suggest that you are not running MySQL 4.0. As of 4.0.2, the behavior you describe disappears: http://dev.mysql.com/doc/mysql/en/Show_database_info.html Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]