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 |
Is mysql owned by oracle?
What does myisamchk do?
How to set mysql variable in php?
What is ndb in mysql?
How to get last inserted id after insert data from a table in mysql?
What is a mysql view?
Why use mysql procedures?
How to present a past time in hours, minutes and seconds?
How would you get the current date in mysql?
using primary can we relate two table, with out foreign key?
What tools available for managing mysql server?
What is back end and front end?
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)