This discussion is archived
7 Replies Latest reply: Dec 14, 2012 3:16 AM by OsamaJweihan RSS

How to get user information

912130 Newbie
Currently Being Moderated
Hi All,

We have created one application. If USER1_ runs this application, then it will execute some set of procedures,packages with the hardcoded USER2_ credentials in that application. Due to this process execution few tables(let us say TABLE1_) is getting updated.

Now my problem is, I want to know the details of USER1. i.e who ran the application.

For this I have tried the below option,
1. Created a trigger on table TABLE1
2. by using 'user' keyword I tried to capture the user credentials.

But, since that updation of table is taking place with the help of hard-coded USER2 credentials, i am getting ouptut as USER2.

But in the reality I have to get USER1 as output.

Please provide the resolution

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points