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 the maximum number of columns per table?

963

How to check if a record exists in a mysql database php?

934

How do I start mysql from command line?

1065

How do I run mysql?

1089

What is “i_am_a_dump” flag in mysql?

1133

what is mysql optimization in brief?

2408

How do I find my mysql username and password?

1000

What is the use of mysql_fetch_array () function in php?

1002

How to delete the repeated records from a table?

1036

How do I restart mysql on windows?

1009

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

2051

What is auto increment in mysql?

1014

What is msql?

1050

Can you tell the difference between mysql_connect and mysql_pconnect? : Mysql dba

1072

How do I quit mysql?

985