Re: Adding Users
Hi!
[FromDocs]
You can do this by starting mysqld with --skip-show-database option..
--skip-show-database
With this option, the SHOW DATABASES statement is allowed only to users who have the SHOW DATABASES privilege, and the statement displays all database names. Without this option, SHOW DATABASES is allowed to all users, but displays each database name only if the user has the SHOW DATABASES privilege or some privilege for the database.
Also there is an SHOW DATABASE privilge in the GRANT statement..you can prevent users from viewing /using show database command..
take a look at here..
http://dev.mysql.com/doc/mysql/en/grant.html
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221
Subject
Written By
Posted
Re: Adding Users
May 22, 2005 07:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.