thanks for your hint in that direction! i'm currently using the latest mysql 3.23, but i guess, i'll upgrade to 4.0 before i get my server up and running. but what i found, and may be more appropriate for my needs is the --safe-show-database option. i just added it to /etc/my.cnf, restarted the server and things were fine again :-)
so that's what i did to my.cnf: [mysqld] safe-show-database HTH anyone else, too... ··· yves at unclassified.de -----Ursprüngliche Nachricht----- Von: "Victoria Reznichenko" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Donnerstag, 26. Juni 2003 11:25 Betreff: Re: SHOW DATABASES user rights > [EMAIL PROTECTED] wrote: > > I have a MySQL server running with some users besides root, that I want to grant > > all privileges for their own databases, but no rights for anything else. > > So to say, I have a user web01 that shall be able to do whatever he wants with the > > database db01. There are more databases, like db02 etc. > > If user web01 runs a 'SHOW DATABASES' command, he'll get to see ALL databases on > > the server, but I don't want him to see them... When the user does a 'USE > > <dbname>;', it says 'access denied'. There must be some special trick to let him > > only see the database(s) he's got rights on. (At least my webhoster managed that > > somehow...) > > > > Anyone an idea what rights I have to assign to get this running? > > Since 4.0.0 user must have SHOW DATABASES privilege to see databases on with he has > no permissions: > http://www.mysql.com/doc/en/Privileges_provided.html > > In 3.23.xx you can run mysqld with --skip-show-database option: > http://www.mysql.com/doc/en/Command-line_options.html > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Victoria Reznichenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
