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]
