OR 12.0 | Revoke Statement

System Reference Summary > System Reference Summary > Statements > OpenROAD SQL Statements > Revoke Statement

Was this helpful?

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.

Syntax:

revoke
          all [privileges] | privilege {, privilege} | object_name {, object_name}
          [on object_type]
          from public | [auth_type] auth_id {, auth_id};

Last modified date: 06/25/2024