Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
what "audit sysdba" and "audit sysoper" do

What db operations are audited by commands "audit sysdba" and "audit sysoper"?
Answers
-
I think that those audit options are useless, they do nothing if enabled.
To audit SYSDBA or SYSOPER actions, you just need to set AUDIT_SYS_OPERATIONS parameter to TRUE.
Any action performed by SYS will be recorded in an audit file ( never AUD$ table ) regardless of the audit options enabled.
-
What db operations are audited by setting the parameter AUDIT_SYS_OPERATIONS to TRUE?
-
all of them
-
Is it audit anyother operation other than new connection as sysdba or sysoper , db shutdown , db startup?
-
yes,
connection as sysdba, startup and shutdown actions, are always audited regardless of any audit setup.
Having audit_sys_operations parameter set on TRUE, all actions of SYS will be audited ( any DML, DDL etc ).