Using the REVOKE Statement


The REVOKE statement is the opposite of GRANT . It is used to take privileges away from a user . For example:

 
 revoke all on employee.* from fred; 

The general form of the revoke statement is as follows :

 
 REVOKE  priv_type  [(  column_list  )] [,  priv_type  [(  column_list  )] ...] ON {  tbl_name  *  *.*  db_name  .*} FROM  user_name  [,  user_name  ...] 

As you can see, it has basically the same clauses as the GRANT statement and can be used to revoke the corresponding privileges.



MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net