This content has been marked as final. Show 6 replies
How to check users and privileges used by noaudit ?
You need to check the system audit views
See the Using Data Dictionary Views to Find Information About the Audit Trail section in the Security Guide
The 'Finding Information About Audited Activities' has what you want.
Well doesn't this view listed on the page of the link section I provided give you that info?
Lists audit trail records concerning GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements throughout the database
And that section says see the database reference for the details
These and others are all part of that view
OBJ_PRIVILEGE VARCHAR2(16) Object privileges granted or revoked by a GRANT or REVOKE statement
SYS_PRIVILEGE VARCHAR2(40) System privileges granted or revoked by a GRANT or REVOKE statement
GRANTEE VARCHAR2(30) Name of the grantee specified in a GRANT or REVOKE statement
Did you even try to do a simple test and see the result in this view or other views?
yes, i tried all of it, and got no information about noaudit users.
but something has changed: the other dba told me that at this morning 6 users were audited, by the noon he removed the audition from 2 of them.
i´m using the query select distinct(user_name) from DBA_STMT_AUDIT_OPTS; to check the audited users, but still different then the users audited on dba_audit_trail on query select distinct(user_name) from DBA_audit_trail;
I was trying to filter by timestamp but the filtering does not worked very well, and kept showing audited users from this day, including morning.
where extended_timestamp > (sysdate-20/24)
ORDER BY timestamp;
Edited by: BrunoSales on 27/04/2012 13:52