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

In which language mysql has been written?

870


What language is used in mysql?

507


What is query log in mysql?

496


How can you calculate the sum of any column of a table?

509


How to delete a table.

514






What do you need to connect php to mysql?

526


What are numeric data types?

551


How to calculate expressions with sql statements?

490


What is the purpose of -> in the mysql terminal?

641


What is a mysql model?

497


What is pdo connection?

462


Is mysql frontend or backend?

482


Suppose you have to collect the first name, middle name and the last name of students from the below table. But, you observe that there few missing values either in the first name, middle name and the last name columns. How will you return the first non-null values?

468


Is mysql a scripting language?

467


What is the latest mysql?

469