Auditing IAM-Authenticated Sessions

Oracle Database Unified Auditing can capture details about sessions that were authenticated using IAM. For more information about IAM Authentication, see Integrating IAM Authentication with Database Tools Connections.

In the UNIFIED_AUDIT_TRAIL view, IAM-related identifiers are recorded for externally authenticated sessions. For example, the IAM user’s OCID may appear in the EXTERNAL_USERID column.

The following example query shows audit records for IAM-authenticated sessions:

SELECT EXTERNAL_USERID, EVENT_TIMESTAMP, ACTION_NAME 
FROM UNIFIED_AUDIT_TRAIL 
WHERE EXTERNAL_USERID IS NOT NULL;

For more information, see Auditing for Database Tools service and Monitoring Database Activity with Auditing.