| audit records generated for a user even after disabling audit for that particular user [message #51940] |
Sat, 22 June 2002 03:58  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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|system_priv> BY SESSION|ACCESS;
Auditing for a single user can not be stopped. Only auditing for all users
can be stopped.
NOAUDIT <statement_opt|system_priv> BY SESSION|ACCESS;
****************************************************************************
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
