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 can you filter the duplicate data while retrieving records from the table?

907

Can mysql handle big data?

962

List data types in mysql? Explain

930

How to use case expression?

964

What is “i_am_a_dump” flag in mysql?

1078

What's the latest version of mysql?

996

Why we use mysql workbench?

915

How to create a new table in mysql?

1054

Where’s database data actually stored?

977

How to convert character strings to dates?

1096

What is clob datatype?

895

How can we get the number of rows affected by query?

1076

In which year mysql created?

982

What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?

1018

How do I fix a crashed mysql database?

967