SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Client User Id and Oracle User ID

404152Jul 10 2006 — edited Jul 17 2006

Hello,
I would like to get the Operating System User Name of the Client, the User Name of the user who sing to the Oracle database, PC Name-Client, and the IP Address-client through Oracle.
I need to create a database trigger that capture all the information above when a new records is created, updated or delete.
I have some users that share tha same User ID for a specific applicaand I need to capture who really made the changes.

I found in this discussion forum the "SYS_CONTEXT", but I don't get the correct information.
Example : PW_USER (User that sign into the Client machine)
AMELIA (User that sign into the Oracle Application)
Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2006

Added on Jul 10 2006

17 comments

2,014 views