Audit DBA accounts - reg
Running ORacle 9i Relase 1 on a windows box. The dba connections are audited in the Event viewer, by default. Is there any other way to audit the database DBA username, atleast during connection.
The event viewer, only reports the os user logging in with sysdba/sysoper privs, I would also prefer the database username.
Re: Audit DBA accounts - reg
You can use a system level trigger to log all connections if you want. You might want to try something like:
CREATE OR REPLACE TRIGGER logon_trg
AFTER LOGON ON DATABASE
-- Audit the login.
-- Gather data using the SYS_CONTEXT('USERENV', '???') function.
Note. Make sure you have a connection open constantly while testing system level triggers. If you make a mistake in a login trigger you might find yourself unable to reconnect.
Click Here to Expand Forum to Full Width