You can revoke OVERRIDE privileges with the REVOKE (SQL form) statement. For example:
REVOKE OVERRIDE [sql_statement_type ... [, sql_statement_type]] CONSTRAINT [constraint_name ... [, constraint_name]] ON [object_name] FROM user_name ...[, user_name]|role_name ...[, role_name]
where
| Syntax Element | Description |
|---|---|
|
The SQL statement type(s) for which OVERRIDE privileges are revoked, INSERT, SELECT, UPDATE, or DELETE. If no SQL statement is specified, the OVERRIDE privilege is revoked for all SQL statement types. |
|
The row level security constraints for which the OVERRIDE privilege(s) are revoked. If no security constraints are specified, the OVERRIDE privileges are revoked from all affected objects. |
|
The object on which the OVERRIDE privileges are revoked. You must specify an object or the system returns an error. |
|
The user(s) or role(s) from which the OVERRIDE privilege(s) are revoked. |