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

Explain federated tables?

3 Answers   Tech Mahindra,


Explain the architecture models of SQL Server?

0 Answers  


Why do we use views instead of tables?

0 Answers  


How do I copy an entire mysql database?

0 Answers  


when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  






What is the maximum length of a table name, database name, and fieldname in MySQL?

3 Answers   Accenture, Pioneer, TISL,


How many TRIGGERS are allowed in MySql table?

0 Answers  


How to run 'mysql' commands from a batch file?

0 Answers  


What are features of mysql?

0 Answers  


How many services is running in sql server?

3 Answers   ACC, V2 Solutions,


Which command is used to view the content of the table in mysql?

0 Answers  


How do I find the size of a mysql database?

0 Answers  


Categories