Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!att!occrsh!occrsh.ATT.COM!srm
From: srm@occrsh.ATT.COM
Newsgroups: comp.databases
Subject: Re: ORACLE SQL*PLUS auditing tables
Message-ID: <143900002@occrsh.ATT.COM>
Date: 27 Jul 90 14:57:00 GMT
References: <10893@spool.cs.wisc.edu>
Lines: 19
Nf-ID: #R:spool.cs.wisc.edu:-1089300:occrsh.ATT.COM:143900002:000:667
Nf-From: occrsh.ATT.COM!srm    Jul 27 09:57:00 1990


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.