Answer Posted / 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 |
Post New Answer View All Answers
What is mysql architecture?
What is a procedure example?
Is mysql and sql are same?
What is query design?
Who developed mysql?
Does adding an index lock a table?
Define REGEXP?
How to show certain selected rows with the value "pcds".
What are procedures in mysql? Explain
How to get nth highest salary from table in a mysql?
How many tables we can create in mysql database?
What is a transaction? Describe mysql transaction properties.
what are the different tables present in mysql? : Mysql dba
How to calculate the difference between two dates?
What are date and time functions in mysql?