System Reference Summary : 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 (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};