Give the syntax of REVOKE commands?
- 1 Answers
- 3928 Views
- I also Faced
- E-Mail Answers
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 view mysql logs?
What are the limitations of mysql?
What are CSV tables?
How to load data files into tables with 'mysqlimport'?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
How can you export the table as an xml file in mysql?
Can foreign key have duplicate values?
What is mysql data directory? How to determine the location of the data directory?
How do I check mysql version?
What is difference between mysqli and pdo?
How to get a list of indexes of an existing table?
Is mysql workbench a dbms?
-
Oracle (3258) - 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)
