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?
Viele Gruesse,
Peter.
--
_________________________________________________________________
Peter Padberg Pyrmonter Str. 42
Webagentur web4.hm 31789 Hameln
Geschaeftsfuehrung Germany
Telefon: +49-5151 60 99 70-0 [EMAIL PROTECTED]
Telefax: +49-5151 60 99 70-1 http://web4.hm
_________________________________________________________________
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
