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
can you tell how can you display the maximum salary in sql? : Mysql dba
What is a data directory?
Why use mysql procedures?
How to connect html form to mysql database using php?
How to extract a unit value from a date and time?
How do I know if mysql is installed on windows?
What are the disadvantages of stored procedures?
How to enter binary numbers in sql statements?
How to use rank function in mysql?
How do I install the latest mysql on ubuntu?
how to add a new column to an existing table?
What is the use of i-am-a-dummy flag in mysql?
Give string types available for column?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
Is mongodb faster than mysql?
