Re: the DBA_OBJ_AUDI_OPTS view

"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:krm2nt0dhudm2u7t7nis4ps6unn4l5hqkl_at_4ax.com...
> Dear all,
>
> Quoting from a book as follows:
> "Viewing Enabled Auditing Options
> The following views offer information about the enabled audit options
> configured in the Oracle database:
> DBA_OBJ_AUDIT_OPTS: A list of auditing options for views, tables, and
> other database objects.
> DBA_PRIV_AUDIT_OPTS: A list of auditing options for all privileges on
> the database.
> DBA_STMT_AUDIT_OPTS: A list of auditing options for all statements
> executed on the database.
> ALL_DEF_AUDIT_OPTS: A list of all default options for auditing
> database objects."
>
> When I describe the first one, DBA_OBJ_AUDIT_OPTS with the test
> database as system:
>
> SQL> desc dba_obj_audit_opts
> Name Null? Type
> ----------------------------- -------- --------------------
> OWNER VARCHAR2(30)
> OBJECT_NAME VARCHAR2(30)
> OBJECT_TYPE VARCHAR2(9)
> ALT VARCHAR2(5)
> AUD VARCHAR2(5)
> COM VARCHAR2(5)
> DEL VARCHAR2(5)
> GRA VARCHAR2(5)
> IND VARCHAR2(5)
> INS VARCHAR2(5)
> LOC VARCHAR2(5)
> REN VARCHAR2(5)
> SEL VARCHAR2(5)
> UPD VARCHAR2(5)
> REF VARCHAR2(5)
> EXE VARCHAR2(5)
> CRE VARCHAR2(5)
> REA VARCHAR2(5)
> WRI VARCHAR2(5)
>
> I can guess most of the columns, but I don't know 'COM', 'LOC', 'IND',
> etc. Besides, the values of all records of the 15 columns are the same
> '-/-'. I really don't get it. Can anyone explain this to me? Thanks in
> advance.
>
> Dino
>

Tip:

*Every* view in the dictionary has comments on column level, and you can also read them in your catalog.sql

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Wed Aug 08 2001 - 11:19:30 CDT