Give the syntax of REVOKE commands?
- 1 Answers
- 3892 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 is mysql common?
How to get help information from the server?
Why we use mysqli instead of mysql?
How to see the database architecture in MySQL??
What is a heap table?
How we can get distinct columns values in mysql?
Why myisam is faster than innodb?
What is mysql default database?
What is meant by mysqli?
What is prepare statement in mysql?
What is current version of mysql?
How can I see mysql database?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
