Robert Montgomery [EMAIL PROTECTED] wrote:
I recently upgraded to mysql 4.0.18. In the past you
could set the option safe-show-databases and that
allowed users to list databases, but only those they
have permissions to see. It seems that this 4.0.18
will only allow users to see ALL databases, or NO
databases, depending on the SHOW_DATABASES field in
the mysql.user table.
No. Without SHOW DATABASES privilege only databases on which user has some kind of
privileges will be listed in the output of SHOW DATABASES command.
Is there any way to allow users to list ONLY the
databases they have permissions on?
Don't give user SHOW DATABASES privilege.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]