From: Dino Hsu Newsgroups: comp.databases.oracle.server Subject: the DBA_OBJ_AUDI_OPTS view Date: Wed, 08 Aug 2001 23:55:18 +0800 Lines: 48 Message-ID: NNTP-Posting-Host: 61-217-213-208.hinet-ip.hinet.net (61.217.213.208) Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: fu-berlin.de 997286114 6401113 61.217.213.208 (16 [41926]) X-Newsreader: Forte Agent 1.8/32.548 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