Give the syntax of Grant and Revoke commands?



Give the syntax of Grant and Revoke commands?..

Answer / monika

grant all on table_name to user_name;

Revoke all on table_name from user_name;

Is This Answer Correct ?    16 Yes 2 No

Post New Answer

More MySQL Interview Questions

How do I restore a mysql database dump file in linux?

0 Answers  


How do I copy an entire mysql database?

0 Answers  


A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  


What is clob datatype?

0 Answers  


What are different types of queries?

0 Answers  






What is the use of mysql_close()?

0 Answers  


What is the difference between mysql_fetch_array() and ysql_fetch_object() ?

0 Answers  


What does mysqli stand for?

0 Answers  


What does mysql flush tables do?

0 Answers  


Is mysql easy to learn?

0 Answers  


What is the use of mysqli_num_rows?

0 Answers  


What is the maximum connection pool size?

0 Answers  


Categories