Robert Montgomery <mogtnomr@stripped> 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
/ /|_/ / // /\ \/ /_/ / /__ Victoria.Reznichenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
