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

How to get a list of all tables in a database?

1010

What is the difference between truncate and delete?

1122

Is number a datatype in mysql?

903

Where’s database data actually stored? Is there a way to see the files which are stored?

937

What is not null in mysql?

947

How do I start mysql manually?

874

How many concurrent queries can mysql handle?

863

What is the datatype of image?

906

How do I clear the command in mysql?

908

What is mysql ndb?

860

how to connect a php script with the mysql database?

993

What is the current mysql version?

961

Can you shard mysql?

882

What is mysqlcheck do?

972

What are the disadvantages of stored procedures?

927