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_skip-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=arch...@jab.org
