Jump to content

[SOLVED] granting user help


sasori

Recommended Posts

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  :(

 

 

 

Link to comment
https://forums.phpfreaks.com/topic/120054-solved-granting-user-help/
Share on other sites

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.