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 do I kill a mysql query?
How do I find users in mysql?
What is relational database in mysql?
What is the purpose of using timestamp data type?
How many ways to get the current time?
Tell us something about heap tables?
What is regex in mysql?
What is view? How can you create and drop view in mysql?
What is procedural api?
Is mysql deprecated?
What is a csv table?
How to make a copy values from one column to another 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)