DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: AUDIT returncode lookup

  1. #1
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510

    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!

  2. #2
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    RETURNCODE Returncode for each command that was executed. If the command was successful, then the value of returncode will be 0
    siva prakash
    DBA

  3. #3
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    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.

  5. #5
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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
  •  


Click Here to Expand Forum to Full Width