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 port is mysql running on?

484


How do I download a mysql community server?

452


How do I save in mysql?

504


How to analyze tables with 'mysqlcheck'?

719


How to delete the repeated records from a table?

515






Why we use mysql database?

491


What is the latest mysql version?

481


What are the difference between and myisam and innodb?

522


What is striped backup

1834


How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

541


What is the limitation of mysql?

487


What are date and time functions in mysql?

581


How is myisam table stored?

559


What is row locking in mysql?

515


What are stored procedures and functions?

480