Hi friends,
Great new feature of Oracle 11g.
AUDIT_SYSLOG_LEVEL
Auditing Oracle software owner’s activities. It traces all events and commands of sysdba,sysoper privileges.Generaly SYS.AUD$ table contains auditing activities.But as Oracle software owner (SYSDBA owned) can easily remove auditing data from this SYS.AUD$
table.
This parameter also privent hacker activity if it captures password of oracle software owner.When AUDIT_SYSLOG_LEVEL and AUDIT_SYS_OPERATIONS are combined, any commands
run as user SYS may be audited using the syslog facility. Since the files used by syslog are owned by root, and a DBA usually does not have access to the root account, DBAs will not be able to remove traces of their activity. Of course, this also applies to intruders who have managed to break into a machine and have gained access to the account of the ORACLE software owner but not to the root account.
AUDIT_SYSLOG_LEVEL enables OS audit logs to be written to the system via the syslog utility, if the AUDIT_TRAIL parameter is set to os. The value of facility can be any of the following: USER, LOCAL0- LOCAL7, SYSLOG, DAEMON, KERN, MAIL, AUTH, LPR,NEWS, UUCP or CRON. The value of level can be any of the following: NOTICE, INFO,
DEBUG, WARNING, ERR, CRIT, ALERT, EMERG.
Offcourse certain commands are accepted by Oracle otherwise you will get ORA-32028: Syslog facility or level not recognized error at database start time.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.