Give the syntax of REVOKE commands?
- 1 Answers
- 3553 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are mysql functions?
What is delimiter in mysql trigger?
How do I select a table in mysql?
How can you make a database as your current database?
How to get a list of indexes of an existing table?
Why do we write stored procedures?
What is InnoDB?
How to save images in MySQL?
How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?
How to create trigger in mysql phpmyadmin?
How many rows can be inserted in mysql at a time?
Where is mysql installed on linux?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
