Manas Guha wrote:Assume you want to trace all sessions created by user XYZ. Then login as privileged user (user who can create BEFORE LOGON trigger and who is granted ALTER SESSION privilege directly, not via role) and:
Note - Not only one session / Not for all Database activity
Now every time user XYZ logs in new sql trace is started.
create or replace trigger trace_xyz_user after logon on xyz.schema begin execute immediate 'alter session set sql_trace=true'; end; /
743136 wrote:since you dismiss only viable options, then no solution is possible.
1. Only one user activity I need to track ( It may connected multiple OS / Machine).
2. I can't apply audit bcz it is production database.
3. Trigger is not sutiable solution here.
Due to some performance issue..for paticular one user.. i have required.