Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Identify which user accesses an Oracle table.
Our ERP system (Glovia) is linked to Oracle. On certain actions, I
need to be able to track which user made an entry to a table. My plan
is to implement a trigger, which puts the username in a field of the
table of interest. To get the username, I tried
select sys_context('USERENV', 'OS_USER') from dual;
which works when a user accesses the table from SQL Plus, but returns "daemon" when the table is accessed from Glovia. Is there anyway to identify the user that is accessing the table through Glovia? Received on Wed Jun 21 2006 - 10:33:47 CDT
![]() |
![]() |