Michael B wrote:
> 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?
It appears that your issue is that your vendor does not supported
what you are trying to do. Talk to Glovia and have them fix if they
are willing: Expect to be disappointed.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Jun 21 2006 - 10:52:35 CDT
