System_Privileges.htm |
Ref: Oracle Release 11.2.1 A list of 46(!!) entries, has shown below, system privileges do not relate to a specific schema or object. ( Please review these documents, Oracle_Privileges2.htm Oracle_Privileges3.htm ) |
ADMIN ALTER ANY CACHE GROUP ALTER ANY INDEX ALTER ANY MATERIALIZED VIEW ALTER ANY PROCEDURE ALTER ANY SEQUENCE ALTER ANY TABLE ALTER ANY VIEW CACHE_MANAGER CREATE ANY CACHE GROUP CREATE ANY INDEX CREATE ANY MATERIALIZED VIEW CREATE ANY PROCEDURE CREATE ANY SEQUENCE CREATE ANY SYNONYM CREATE ANY TABLE CREATE ANY VIEW CREATE CACHE GROUP CREATE MATERIALIZED VIEW CREATE PROCEDURE CREATE PUBLIC SYNONYM CREATE SEQUENCE CREATE SESSION CREATE SYNONYM CREATE TABLE CREATE VIEW DELETE ANY TABLE DROP ANY CACHE GROUP DROP ANY INDEX DROP ANY MATERIALIZED VIEW DROP ANY PROCEDURE DROP ANY SEQUENCE DROP ANY SYNONYM DROP ANY TABLE DROP ANY VIEW DROP PUBLIC SYNONYM EXECUTE ANY PROCEDURE FLUSH ANY CACHE GROUP INSERT ANY TABLE LOAD ANY CACHE GROUP REFRESH ANY CACHE GROUP SELECT ANY SEQUENCE SELECT ANY TABLE UNLOAD ANY CACHE GROUP UPDATE ANY TABLE XLA |
Note: By default , SYSTEM user doesn’t have the privilege to
analyze any non system table (Other schema’s table).
For the system user, to ANALYZE ANY non system tables (other schema tables), you must render system user with "grant ANALYZE ANY to system " after login in as user/ as sysdba. SQL>Baba / as sysdba |
Example :
SELECT USERNAME, GRANTED_ROLE, DEFAULT_ROLE Note: Mr. Scott had fewer roles, (by default)
|