This figure illustrates the environment in which you can audit proxy users. In this figure, from left to right, top to bottom, are the following components:

• A client connects to a mid-tier application called AppHR.

• The AppHR mid-tier application passes the user's authentication to the database server.

• Within the database is the audit trail. To find information about this user's activities, you can query the following columns from the DBA_AUDIT_TRAIL data dictionary view:

  • DBA_AUDIT_TRAIL.COMMENT_TEXT = 'Authenticated by: PROXY; …'

  • DBA_AUDIT_TRAIL.PROXY_SESSIONID = XYZABC

  • DBA_AUDIT_TRAIL.ACTION_NAME = 'LOGON'

  • DBA_AUDIT_TRAIL.SESSIONID = XYZABC

  • DBA_AUDIT_TRAIL.USERNAME = 'APPHR'

  • DBA_AUDIT_TRAIL.ACTION_NAME = 'PROXY AUTHENTICATION ONLY'

Copyright © 2006, 2012, Oracle and/or its affiliates. All rights reserved.
Legal Notices