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?
RETURNCODE Returncode for each command that was executed. If the command was successful, then the value of returncode will be 0
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$
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!