Q:

How to Grant permission to a user so that (s)he can execute not more than a specific number of queries in an hour

hamza
Save to bookmark
|
2022-05-18
|
  183 
0

How to Grant permission to a user so that (s)he can execute not more than a specific number of queries in an hour.

Sql programming,
login and add your own answer to this question

All Answers

hamza
2022-05-18
need an explanation for this answer? contact us directly to get an explanation for this answer 

create user steffi@localhost identified by 'mypassword';
grant select on posts.* to steffi@localhost 
identified by 'mypassword' with MAX_QUERIES_PER_HOUR 50;
flush privileges;

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

Similar questions

need a help?

find thousands of online teachers now