Re: Help:How do you trace in this application?

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Mon, 17 Dec 2007 15:38:24 GMT
Message-ID: <QJw9j.4440$mF1.3655@newsfe08.phx>

emdproduction_at_hotmail.com wrote in news:673f5b95-45d9-4a14-9fb4- 95401b96f3bd_at_x69g2000hsx.googlegroups.com:

> Group,
>
> One of my application is going through an application server. All the
> user is connecting through one user, IP address is the same, and
> programe is the same.
>
> I tried
>
> CREATE OR REPLACE TRIGGER logon_trigger
> AFTER LOGON
> ON DATABASE
> DECLARE
> uid VARCHAR2(64);
> BEGIN
> SELECT ora_login_user ||':'|| SYS_CONTEXT('USERENV', 'OS_USER')
> INTO uid
> FROM dual;
> dbms_session.set_identifier(uid);
> END logon_trigger;
> /
>
> But all the client_identifier is the same.
>
> How could I trace an particular user if he logs in into the
> application?

How do you programatically identify the user of interest? Received on Mon Dec 17 2007 - 09:38:24 CST