GRANT CREATE/DROP

2003-12-22 Thread Niklas Saers
Hi all, 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

Re: GRANT CREATE/DROP

2003-12-22 Thread 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

GRANT create/drop for temp tables

2002-03-25 Thread Ray Rodriguez
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

Re: GRANT create/drop for temp tables

2002-03-25 Thread 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