the DBA_OBJ_AUDI_OPTS view

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 Received on Wed Aug 08 2001 - 10:55:18 CDT