In the last episode (Aug 03), web4.hm - Peter Padberg said:
> Hi!
>
> I updated my MySQL from 3.23 upto 4.0 and now began the problems!
>
> All Users in my mysql-db are with this privileges:
> INSERT INTO `user` (`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`)
> VALUES
> ('localhost', 'SOME_USER', 'SOME_ENCRYPTED_PASSWORD', 'N', 'N', 'N', 'N', 'N', 'N',
> 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'Y', 'Y', 'N', 'N', 'N', '', '',
> '', '', 0, 0, 0),
>
> And Show_db_priv is definitiv to N.
>
> But when I login as a user I see ALL other databases.
>
> I only want that the users do not see the other databases. Must I
> edit something else, I read the online-help, but it seems that I made
> everything right. :(
>
> Did I made something wrong or is it a bug?
>From http://www.mysql.com/doc/en/GRANT.html :
`SHOW DATABASES' `SHOW DATABASES' shows all databases.
You have that set (the Show_db_priv field). Revoke that privilege from
your users if you only want them to see databases they have access to.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
