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 the advantage of stored procedures, triggers and indexing in mysql
How do I edit a table in mysql?
how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...
What is mysqladmin flush hosts?
How do I stop a mysql command?
How to update database permissions/privilages.
How to filter data from a mysql database table with php?
Where is the myisam table stored?
Tell us something about heap tables?
how can you test for null values in a database? : Mysql dba
How to run a sql statement?
How to decrement dates by 1 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)