Ok, I figured it out. My scenario Had "Deactivate show databases" checked, so users got access denied error when trying to exec show databases. Granted show databases to a user, and now they see all of the databases.
New Scenario Unchecked "Deactivate show databases" Removed granted show database priv, and now all they see is the databases they have access to. Sorry, I'm not used to that being built in feature turned on by default, within MSSQL you must revoke that priv from the public role, and then users only see what they have access to. Thanks for pointing me in the right direction, John -----Original Message----- From: Stephen Edberg [mailto:sbedb...@ucdavis.edu] Sent: Sunday, February 15, 2009 7:07 PM To: John Cc: mysql@lists.mysql.com Subject: Re: Show Databases issue On Sun, 15 Feb 2009, John wrote: > How do I disable showing ALL the databases on the server for a normal user > that only has access to a single database? So that when a user runs show > databases, they only get a list of ones they can access. I've seen this done > before. > > Sorry if it's a newb question. > > John It's always helpful to specify the MySQL version when you ask. If you're using 5.0 or above (and I think 4.0+), there is a 'show databases' option which specifies the default behavior, and a 'show databases' privilege to override it. See: http://dev.mysql.com/doc/refman/5.0/en/show-databases.html http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_ski p-show-database I don't believe MySQL 3 has that option, but then you probably aren't using (and shouldn't be using) MySQL 3 anyway. steve edberg ........................................................... . Steve Edberg sbedb...@ucdavis.edu . . Computer Consultant University of California, Davis . ........................................................... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=j...@webhostingspot.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
