Folks,
We are currently using the following "watch the DBA" approach for SOX.
- Lock SYS/SYSTEM except for upgrades/one-off patches/patch sets
- Each DBA logins in "AS SYSDBA". We have turned on SYS_AUDIT_OPERATIONS
- We are auditing all DDL including "AUDIT all on sys.aud$ by access"
Here is the problem with this approach:
- Logins for db user " X AS SYSDBA" create the AUD$ audit record for SYS
(not X). Is there any way to work around this problem?
- The OS audit files are created with "oracle" OS account privileges and
can be removed by the "oracle" account. Is this possible to send the
information to non-Oracle logs? There is some mention in metalink that this
is possible for certain operating systems but it is not clear which ones.
Also, is there any white paper for "Oracle DBA SOX Compliance"?
Regards,
Parvez
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 01 2006 - 13:52:32 CST