Answer Posted / rajan vardawaj
The generic syntax for revoke is as following REVOKE
[rights] on [database] FROM [username@hostname] Now rights
can be: a) ALL privilages b) Combination of CREATE, DROP,
SELECT, INSERT, UPDATE and DELETE etc. We can grant rights
on all databse by usingh *.* or some specific database by
database.* or a specific table by database.table_name.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do I show columns in mysql?
How to display odd rows in student table in mysql?
Is mysql a backend?
What is foreign key in mysql?
how to add a new column to an existing table?
What are views in mysql?
How to convert dates to character strings?
Can we write procedure in mysql?
How to display top 10 rows in mysql?
Can I install mysql on mac?
How to get a list of indexes of an existing table?
How is myisam table stored?
What is the innodb in mysql?
What is the maximum connection pool size?
all the queries used in sql