7 Replies Latest reply: Dec 14, 2012 5:16 AM by OsamaJweihan RSS

    How to get user information

      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