5 messages in com.mysql.lists.bugsRe: Show_db_priv ignored| From | Sent On | Attachments |
|---|---|---|
| Wouter de Jong | 13 May 2004 03:30 | |
| Sergei Golubchik | 13 May 2004 04:05 | |
| Wouter de Jong | 13 May 2004 04:51 | |
| Sinisa Milivojevic | 13 May 2004 05:25 | |
| Paul DuBois | 13 May 2004 06:39 |
| Subject: | Re: Show_db_priv ignored |
|---|---|
| From: | Sergei Golubchik (se...@mysql.com) |
| Date: | 05/13/2004 04:05:34 AM |
| List: | com.mysql.lists.bugs |
Hi!
On May 13, Wouter de Jong wrote:
Hello,
We have MySQL 4.0.18 (Linux, source-compiled) running on some servers, and for some reason it ignores the Show_db_priv
--------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| Host | User | password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv |
Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv |
Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type
| ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates |
max_connections |
+-----------------+----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+
| 212.204.254.% | almetaal | 60a1476777a54240 | N | N | N
| N | N | N | N | N | N
| N | N | N | N | N | N
| N | Y | Y | N | N
| N | | | | |
0 | 0 | 0 |
As you can see, Show_db_priv is 'N', but I can still view _ALL_ databases:
Show_db_priv allows to see databases you have NO privileges for. If you have some privileges for some database you will be able to see it independent on Show_db_priv. And above you have global Create_tmp_table_priv and Lock_tables_priv - that is you have these privileges in ALL databases, thus you see all databases.
Regards, Sergei
-- __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <se...@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ www.mysql.com