Data Dictionary Information


You can, again, find information concerning both auditing and privileges in the data dictionary, but only if you have SYSOPER, SYSDBA, or privileges to view the views.

The following list of data dictionary views provides information on auditing:

  • DBA_SYS_PRIVS contains a list of all the system privileges granted to users or to roles.

  • SESSION PRIVS contains a list of all the system-level privileges currently available to the given user.

  • DBA_TAB_PRIVS contains a list of all the grants on any objects in the database (the TAB in the name is misleading in this case; it is not just on tables).

  • DBA_COL_PRIVS lists all the object column grants in the database.

  • ALL_DEF_AUDIT_OPTS lists all the default audit options.

  • DBA_STMT_AUDIT_OPTS lists all statement auditing options.

  • DBA_PRIV_AUDIT_OPTS lists all privileges auditing options.

  • DBA_OBJ_AUDIT_OPTS lists all schema object auditing options.

  • DBA_AUDIT_TRAIL provides access to all audit trail entries.

  • DBA_AUDIT_EXISTS provides access for all audited EXISTS/NOT EXISTS statements.

  • DBA_AUDIT_OBJECT contains records concerning schema objects.

  • DBA_AUDIT_SESSION contains records concerning all connect and disconnect entries.

  • DBA_AUDIT_STATEMENT contains statement auditing records.



    Oracle 9i Fundamentals I Exam Cram 2
    Oracle 9i Fundamentals I Exam Cram 2
    ISBN: 0789732653
    EAN: 2147483647
    Year: 2004
    Pages: 244
    Authors: April Wells

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net