-
AUDIT returncode lookup
I truly searched but could not find a way of turning the returncode
in the following query into a description.
select timestamp#, userid, spare1, action#, b.name, returncode
from sys.aud$ a, sys.audit_actions b
where a.action# = b.action
order by 1 desc
Where do I lookup the returncode meaning?
Thanks!
-
RETURNCODE Returncode for each command that was executed. If the command was successful, then the value of returncode will be 0
siva prakash
DBA
-
prakashs43,
Please read the question a little closer. The question is not about command resturn codes.
The question is about the returncode column in sys.aud$
Thanks
-
From Reference:
RETURNCODE
Oracle Server message code generated by the
action. Some useful values:
zero: the action succeeded
2004: security violation
And ORA-02004 is security violation error, so probably it is ORA error number.
-
Now I understand! The error is related to the overall ORA errors.
prakashs43 did read my question correctly! It was my misunderstanding that was the block.
Thanks a lot guys!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|