Give The Syntax Of REVOKE Commands
The generic syntax for revoke is as followingREVOKE [rights] on [database] FROM [username@hostname]Now rights can be:a) ALL privilagesb) 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.
2009-2016 downloadmela.com. All rights reserved.