Copyright © 2006, 2014, Oracle and/or its affiliates. All rights reserved.
Legal Notices
Figure dbseg_vm_004.png 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 UNIFIED_AUDIT_TRAIL data dictionary view:
UNIFIED_AUDIT_TRAIL.DBPROXY_USERNAME = 'apphr' (Proxy user for user jackson)
UNIFIED_AUDIT_TRAIL.PROXY_SESSIONID = 3205062574 (ID for the apphr proxy user login)
UNIFIED_AUDIT_TRAIL.ACTION_NAME = 'CREATE TABLE' (User jackson's actions)