Skip to Main Content

APP USER though Remote

NS150883Sep 7 2015 — edited Sep 10 2015

Hi All,

I am having a challenge in getting the APP_USER name of the Remote DB.

Solution Built is: I have a Apex installed on DB "X" (X SID) and the base tables are on "Y", DB link is created on X for accessing "Y" (Y SID), we created triggers to log the User which has modified the data on Y tables into an Audit table, though Apex.

Issue: As data changes are happing over DB Link, always the username populated is DB link user instead of Apex user.

Alternatives: Pass the APP_USER (username) as a Value along with data (which needs structure changes )

Need help to provide any alternative which will capture this actual user name from Apex Login.

This post has been answered by fac586 on Sep 8 2015
Jump to Answer
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Oct 8 2015
Added on Sep 7 2015