Home » RDBMS Server » Security » audit records generated for a user even after disabling audit for that particular user
audit records generated for a user even after disabling audit for that particular user [message #51940] Sat, 22 June 2002 03:58 Go to next message
pinky
Messages: 26
Registered: May 2002
Junior Member
Hello All,
Audit records with action_name 'SESSION REC' are inserted in sys.aud$ for a user even after disabling audit option for that particular user.

What should we do to completely disable auditing
for a particular database user.
I have tried
NOAUDIT SESSION BY USERNAME,
NOAUDIT DEFAULT BY USERNAME,
NOAUDIT ALL PRIVILEGES BY USERNAME
But even then , action_name -'SESSION REC' records are inserted in sys.aud$ for that particular user.

Kindly help....
Re: audit records generated for a user even after disabling audit for that particular user [message #51943 is a reply to message #51940] Sat, 22 June 2002 07:11 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Hello, i am also very curious with the same issue.
***************************************************************************
It is not possible to stop auditing for a single user if the AUDIT statement
enables auditing for all users. Is this your case?
Example:
AUDIT <statement_opt&#124system_priv> BY SESSION&#124ACCESS;
Auditing for a single user can not be stopped. Only auditing for all users
can be stopped.
NOAUDIT <statement_opt&#124system_priv> BY SESSION&#124ACCESS;
****************************************************************************
Anyhow, If above scenario is not your case,
getting action_name ='SESSION REC' in aud$ is quite a prolonged discussion.
I am not very sure whether it is a BUG or NOT. Oracle says so. But i couldnt
find any more info on the same.
Please update me, if you find any more info

Mahesh Rajendran
Previous Topic: how to audit sql statment thr' audit /trigger in 8.1.7
Next Topic: DBMS_OBFUSCATION_TOOLKIT
Goto Forum:
  


Current Time: Thu Mar 28 17:16:59 CDT 2024