3. Statements : OpenROAD SQL Statements : Revoke Statement
 
Share this page                  
Revoke Statement
The revoke statement revokes privileges. It removes database privileges or role access granted to the specified users, groups, roles, or PUBLIC. (To confer privileges, use the grant statement (see Grant (privilege) Statement).) You cannot revoke privileges granted by other users.
This statement has the following syntax:
revoke
          all [privileges] | privilege {, privilege} | object_name {, object_name}
          [on object_type]
          from public | [auth_type] auth_id {, auth_id};