Padraig O'Sullivan

Subscribe to Padraig O'Sullivan feed
Padraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.comBlogger21125
Updated: 16 hours 55 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 SETPadraighttp://www.blogger.com/profile/17562327461254304451noreply@blogger.com0

Pages