Give the syntax of REVOKE commands?
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 |
How to drop an existing view in mysql?
How to convert numeric values to character strings?
What is the hostname for mysql database?
What is the storage engine for mysql?
Why myisam is faster than innodb?
What is database in php mysql?
How do I insert multiple rows in a table?
How to create trigger in mysql phpmyadmin?
How to use rank function in mysql?
What is the purpose of -> in the mysql terminal?
What are the differences between char and varchar?
Explain the storage engines in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)