[SOLVED] granting user help

[sasori]

let's say i want to grant a user with all of the data privileges except the structure and administration in one blow? how am gonna command that?

because if am gonna do this thing

 

GRANT ALL PRIVILEGES ON *.* to 'dummy'@'localhost' identified by 'pass';
with MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0;

 

the user will be able to have administration and structure privileges 

 

 

 

[fenway]

ALL? Bad idea...

[Mchl]

This should work

 

GRANT SELECT, INSERT, UPDATE, DELETE ON *.* to 'dummy'@'localhost' identified by 'pass';
with MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0;

 

 

[sasori]

This should work

GRANT SELECT, INSERT, UPDATE, DELETE ON *.* to 'dummy'@'localhost' identified by 'pass';
with MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0
MAX_USER_CONNECTIONS 0;

 

how bout without having to type select, insert, update, delete ? is there any short cut? because as we all know, if i will type Grant All privileges , not just the data privileges alone will be given.but including the structure and administration privileges will be included.

[Mchl]

Doesn't seem so:

 

http://dev.mysql.com/doc/refman/5.0/en/grant.html