Add the following line to the connect script -
call dbms_session.set_identifier('VALUEOF(NQ_SESSION.USER)')
This will then be available as the CLIENT_ID attribute when querying session history and also be available in the audit trail on queries.
EG. Select sid, client_identifier from v$session
EG. Select sid, client_identifier from v$session
No comments:
Post a Comment