Home » RDBMS Server » Security » Can a Schema Owner's id and objects be audited?
Can a Schema Owner's id and objects be audited? [message #172216] Mon, 15 May 2006 09:28 Go to next message
justaname23
Messages: 14
Registered: April 2001
Junior Member
Auditing -- Beginner.
Hello!

We have some auditing issues going around the company. One of the topics raised were 'Schema owner' cannot be audited. The gurus' claim is "if I own some tables and give select, insert, delete, update privileges to others, then we can audit/log changes made to my schema by those ids, but the DDL or DML changes that I make to my schema cannot be audited/logged."

Is this true? Can someone throw some light?

Appreciate,
Smitha
Re: Can a Schema Owner's id and objects be audited? [message #172225 is a reply to message #172216] Mon, 15 May 2006 10:21 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Is this true?
No.
An audit on all DDL/DML can be done (including SYS operations).
http://www.oracle-base.com/articles/8i/Auditing.php
Previous Topic: Oracle Passwords
Next Topic: View the priviledges of a user/account
Goto Forum:
  


Current Time: Fri Mar 29 03:50:09 CDT 2024