Re: Show_db_priv setting ignored

2004-12-01 Thread Fraser Campbell
On Wednesday 01 December 2004 22:09, Fraser Campbell wrote: > The manual states "As of MySQL 4.0.2, you will see only those > databases for which you have some kind of privilege, if you > don't have the global SHOW DATABASES privilege." so I see > two possibilities: > > - users have the global SHO

Show_db_priv setting ignored

2004-12-01 Thread Fraser Campbell
Hi, It seems that all of my users can issue the "SHOW DATABASES" command and receive a list of all databases even though their Show_db_priv setting is N. I am running mysql 4.0.16. The manual states "As of MySQL 4.0.2, you will see only those databases for which you have some kind of privilege,