List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 2 2003 11:24pm
Subject:Re: Update from 3.23 to 4.0
View as plain text  
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
	dnelson@stripped
Thread
Update from 3.23 to 4.0web4.hm - Peter Padberg3 Aug
  • Re: Update from 3.23 to 4.0Dan Nelson3 Aug