grant all on table_name to user_name; Revoke all on table

Give the syntax of Grant and Revoke commands?

Question Posted / monika

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is required to create mysql database?

990

Which storage engine is best in mysql?

952

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1387

How can we find out which auto increment was assigned on Last insert?

1100

What is save point in mysql?

959

How to use sum function in where clause in mysql?

964

What is procedure in mysql?

940

What is the hostname for mysql database?

1025

What is mysql and how it works?

983

What is mysql optimization?

913

How do I completely remove mysql from windows?

972

What are the three types of queries?

918

Can you tell few best practices to be followed for optimization in sql?

904

Write a query to count the number of rows of a table in mysql.

937

How to drop an existing view in mysql?

927