Hi all, I've got a number of users who have their username on the format 'xxxxx_n' where xxxxx is a string and n is a one-decimal number. I want them to have full access to one, and only one, database. That means, they should be able to do CREATE TABLE but not CREATE DATABASE. When I give the CREATE permission, they get to create databases that match xxxxx_n where _ is any character. Yet when I remove CREATE permission, they cannot create tables. How do I disable CREATE DATABASE without disabling CREATE TABLE?
Here is an example: mysql> show grants for 'netto_4'; +--------------------------------------------------------------------------------------------------+ | Grants for [EMAIL PROTECTED] | +--------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'netto_4'@'%' IDENTIFIED BY PASSWORD '446a37200c856ce9' | | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `netto_4`.* TO 'netto_4'@'%' | +--------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec) Cheers Niklas Saers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]