audit_trail question 9.2/10.2
From: Newman, Christopher <cjnewman_at_uillinois.edu>
Date: Mon, 27 Oct 2008 14:33:57 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34101C6EEA8@ADMINMAIL1.ui.uillinois.edu>
Date: Mon, 27 Oct 2008 14:33:57 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34101C6EEA8@ADMINMAIL1.ui.uillinois.edu>
If using a pfile, what goes in sys.aud$ when audit_trail is set to DB?
We ran into a scenario where we want to change auditing on a DB, but the
pfile has audit_trail=NONE, hence we have to bounce. I think if we set
it to DB across the enterprise, we can turn auditing on and off at will
via the 'AUDIT XXX' command. Does setting this parm to DB have any
effect other than allowing you to turn auditing on and off, and
directing the audited information to sys.aud$? Does simply setting it
to 'DB' cause info to go in the sys.aud$, even if you haven't enabled
auditing?
Thanks- Chris
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 27 2008 - 14:33:57 CDT