Give the syntax of Grant and Revoke commands?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different mysql database engines?

811


Is mysql still popular?

702


What is mysql sleep process?

745


How do I find mysql location?

688


How is myisam table stored?

760


What is the latest version of php and mysql?

912


What are the functions used to encrypt and decrypt the data present in mysql?

770


Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

798


How do I stop a mysql service?

776


Why should I use mysql?

737


How to connect html form to mysql database using php?

725


Does insert statement lock the table?

729


What are the difference between now and current_date in mysql?

1012


How to create a table index in mysql?

732


What is max connections in mysql?

725