Padraig O'Sullivan

Subscribe to Padraig O'Sullivan feed
Updated: 17 hours 53 min ago

Audting SYSDBA Users

Tue, 2008-11-25 16:14
I recently came accross this feature in Oracle introduced in 9i where all operations performed by a user connecting as SYSDBA are logged to an OS file. I'm sure most DBA's are familiar with thisfeature already but I have only just been enlightened!!To enable this feature auditing must be enabled and the AUDIT_SYS_OPERATIONS parameter must be set to TRUE. For example:sys@ORCLINS1> ALTER SYSTEM SETPadraig