Use the REVOKE statement to remove various privileges from a specified users or group of users within the OpenEdge database.

There are two forms of REVOKE statement:
  • Revoke database-wide privileges, either system administration (DBA), general creation (RESOURCE), audit administration (AUDIT_ADMIN), audit archive (AUDIT_ARCHIVE), or audit insert (AUDIT_INSERT).
  • Revoke various privileges on specific tables and views.

Syntax

The syntax for using the REVOKE statement to revoke database-wide privileges is:
REVOKE { RESOURCE , DBA, AUDIT_ADMIN, AUDIT_ARCHIVE, 
AUDIT_INSERT} FROM { username [ , username ] , ... } 
[ RESTRICT | CASCADE ] [ GRANTED BY ANY_USER ];

If the REVOKE statement specifies CASCADE, revoking the access privileges from a user also revokes the privileges from all users who received the privilege from that user.

If the REVOKE statement specifies neither RESTRICT nor CASCADE, the behavior is the same as for CASCADE.

Note:
  • CASCADE is not supported for AUDIT_ADMIN, AUDIT_ARCHIVE, and AUDIT_INSERT privileges.
  • Only the user who granted audit privilege can revoke it.

For more information, see Revoke privileges.