Oracle in a Nutshell

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. ...