How to Trace a User Whom Connects to the Database Through an Application? (Doc ID 743967.1)

Last updated on JULY 17, 2017

Applies to:

PL/SQL - Version: 9.2.0.1 to 11.2.0.0 - Release: 9.2 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 23-FEB-2012***

Goal

Provide sample code as how to trace a user which connects through an application.

The code is executed from PL/SQL indirectly by way of a Logon Trigger.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms