beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) (07/27/90)
In SQL*PLUS how does one turn on auditing? I tried the following to try to see if a table was getting locked: SQL> Audit all on SHIFT by access; Audit succeeded SQL> lock table SHIFT in exclusive mode; Table locked SQL> select * from audit_trail; No records selected Shouldn't locking the table SHIFT leave a record in the audit trail? Am I looking at the wrong audit table?
srm@occrsh.ATT.COM (07/27/90)
In response to the question of beverly@ai.cs.wisc.edu:
>In SQL*PLUS how does one turn on auditing?
In order to turn on auditing, edit your "init.ora" file as follows:
Version 5.1:
audit_trail 1
Version 6.0
audit_trail=TRUE
Default distribution is 0 (not auditing). Be aware of the fact that
audit_trail table will grow forever. It would be wise to monitor the
size of that table and take appropriate action when necessary.
--
Steven R. McMaster UNIX(R) mail: ...!uunet!att!occrsh!srm
AT&T Network Systems
Oklahoma City Works Any opinions expressed in the message above are
srm@occrsh.att.com mine, and not necessarily AT&T's.
beverly@ai.cs.wisc.edu (Beverly Seavey (-Kung)) (08/01/90)
>Version 5.1: > audit_trail 1 > >Default distribution is 0 (not auditing). I already have the line: audit_trail 1 in my init.ora ( vers. 5). I have also restarted the system ( warm, that should be enough, right?) There must be another flag somewhere. My impression, from reading the manuals, is that the line in the init.ora is to enable system auditing. There should be user-initiated and -oriented auditing too. In any case, I have everything that I can find turned on for both, and I'm not getting any audit records that I can tell. > > > >