audit individual users who have SYSDBA priv
795855Aug 4 2011 — edited Aug 4 2011Hi,
we have granted 5 users SYSDBA priv, and would like to be able to audit them individually when they access the db. we are writing the audit files to the SYSLOG.
tyhe problem is that when a user logs onto db using their username but includes 'as sysdba' they automatically default to user SYS. i.e:
SQL> conn SYSUSER1 as sysdba
Connected.
SQL> sho user
USER is "SYS"
and this user is is recorded in the audit log under SYS database user, so we are not able to individually identify a specific user who logs in using SYSDBA.
Does anyone have any ideas how to get around this? so that we can track users individually who connect as their db username but also use SYSDBA?
Thanks,
firefly