Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Unhappy Unanswered: Auditing - not getting terminal id in SYS.AUD$

    I am using auditing in an Oracle 9.2.0.4 database running on Windows 2000 Server.

    I am auditing all transactions by access.

    I get all information returned in SYS.AUD$ except terminal and userhost. I think I will not get userhost unless in distributed environment which is okay. I need the terminal ID. The SPARE1 column gives me user login and domain. For instance SPARE1 column is populated with ET/john.doe where john.doe is the user login to the ET domain. My terminal id is something along the lines of C0001234. This is what I need and am not getting.

    Can anyone help?

    Thanks

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    I am not sure but You can get this information from DBA_AUDIT_TRAIL data dictionary view.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Mar 2004
    Posts
    2
    Originally posted by Hings
    I am not sure but You can get this information from DBA_AUDIT_TRAIL data dictionary view.
    This view does not return any rows. DBA_AUDIT_OBJECTS does but it is just a view on the SYS.AUD$ table. So the machine name is not entered there either.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •