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 mysql community server?

494

How do I stop a mysql command?

491

Is mysql open source?

486

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

630

How does mysql encrypt passwords?

488

Why to use char instead of varchar in the database?

571

What's new in mysql 8?

568

Should I use pdo or mysqli?

476

write a command to view the content of the table

500

How do I set user privileges in mysql?

484

What are the different data types in mysql?

474

What is row locking in mysql?

513

How do I select a table in mysql?

496

What are the column comparisons operators?

624

How do I start mysql in mysql workbench?

518