From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: the DBA_OBJ_AUDI_OPTS view
Date: Wed, 8 Aug 2001 18:19:30 +0200
Message-ID: <997287573.16344.0.pluto.d4ee154e@news.demon.nl>
References: <krm2nt0dhudm2u7t7nis4ps6unn4l5hqkl@4ax.com>
NNTP-Posting-Host: sybrandb.demon.nl
X-NNTP-Posting-Host: sybrandb.demon.nl:212.238.21.78
X-Trace: news.demon.nl 997287573 pluto:16344 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@nl.demon.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Lines: 63



"Dino Hsu" <dino1@ms1.hinet.net> wrote in message
news:krm2nt0dhudm2u7t7nis4ps6unn4l5hqkl@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