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
How can I connect mysql database?
How do I start mysql?
What is the difference between heap table and temporary table?
What is procedures in mysql?
How do I install mysql?
How do I disable mysql?
What are the similarities between a function and a procedure?
What is mysql in linux?
What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
can you tell what are the different set operations available in mysql? : Mysql dba
What are the 3 main types of search queries?
What does innodb stand for?
How to dump a table to a file with 'mysqldump'?
How to create table with same structure of student table in mysql?
What is the difference between b-tree and hash indexes?