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 |
What is InnoDB?
What is 'mysqldump'?
What is the difference between the primary and unique key in mysql?
What is a tinyint?
How to load data from a text file into a table?
How can you increase the performance of mysql select query?
What are the differences between mysql vs sql server?
Can you tell how to find the number of rows in a resultset using php?
what is collation? how many types of installations in sql server?
Is mysqli faster than mysql?
What is processlist in mysql?
How to use mysqldump to create a copy of the database?
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)