How To Interpret Return Code In Dba_audit_object
AS PER MY UNDERSTANDING THE VALUE 0 IN RETURNCODE IS SUCCESS AND REST FAILURE.IS THERE ANY WAY TO FIND THE CAUSE OF THE FAILURE FROM THE RETURN CODE.I AUDITED A TABLE FOR A PARTICULAR USER AND I FOUND 0 IN RETURN CODE FOR SOME ROWS AND SOME NUMBER FOR REST.NOW THE CUSTOMER TELLING ME THAT HE MADE ALL SUCCESS UPDATION AND HE IS ASKING THE REASON FOR THE FAILURE.HOW CAN I FIGURE OUT THIS FROM DATABASE.
return code from where?
return code can be customized, I can make 0 failure if I wish
neither 0 is succesful and rest is failure, it depends
Yes you can customize,I agree with you.The returncode from dba_audit_object.But how will i know what is the cause for failure.
Oracle Server message code generated by the action. Some useful values:
zero: the action succeeded
2004: security violation
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
Click Here to Expand Forum to Full Width