Name
Miscellaneous Privileges
Synopsis
The following system privileges do not fall into any of the earlier categories:
- ANALYZE ANY
Gives the privilege to analyze any table, cluster, or index in any schema.
- EXEMPT ANY
Gives the privilege to bypass application-driven security policies. New with Oracle9i.
- FLASHBACK ANY TABLE
Gives the privilege to issue a SQL flashback query on any table, view, or materialized view in any schema. You can still use the DBMS_FLASHBACK built-in package’s procedures without this privilege. New with Oracle9i.
- FORCE TRANSACTION
Gives the privilege to force the commit or rollback of any of the user’s distributed transaction in the local database.
- FORCE ANY TRANSACTION
Gives the privilege to force the commit or rollback of any distributed transaction in the local database or induce the failure of a distributed transaction.
- GRANT ANY PRIVILEGE
Gives the privilege to grant any system privilege.
- GRANT ANY OBJECT PRIVILEGE
Gives the privilege to grant any object privilege. New with Oracle9i.
- [GLOBAL] QUERY REWRITE
Gives the privilege to enable query rewrite on a materialized view or to create a function-based index. The GLOBAL keyword acts like the ANY keyword. New with Oracle8i.
- RESUMABLE
Gives the privilege to enable resumable space allocation. New with Oracle9i.
- SELECT ANY DICTIONARY
Gives the privilege to query any data dictionary object in the SYS schema, which lets the user selectively override the setting of the O7_DICTIONARY_ACCESSIBILITY initialization parameter. ...
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.