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'