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.