Re: GRANT CREATE/DROP

[Victoria Reznichenko]

Niklas Saers [EMAIL PROTECTED] wrote:
 
 I've got a number of users who have their username on the format 'x_n'
 where x 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 x_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?

If you want to use '_' character in the database name, you should specify it as '\_' 
in the GRANT command. For example:

GRANT ... ON `netto\_4`.* TO ..

 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)
 


-- 
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]

Re: GRANT create/drop for temp tables

[Paul DuBois]

At 18:28 -0500 3/25/02, Ray Rodriguez wrote:
This is either a mysql feature request (who would I send it to?) or a
question.  I've looked at the documentation and could not find a way to do
this. 

Is there a way to grant create/drop access specifically for temporary
tables? I have a situation where I need to use a create temporary..select
statement and later use a select statement to get some data, and later
drop the temporary table.  I would like to do this without giving create
and especially drop access to the regular non-temporary tables in the
database.

You could set up another database that's used only for temporary tables
and create the tables there.


Thanks,
Ray Rodriguez


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php