Without having Glovia modify their product, can you think of any way
that I could implement a trigger that can identify which user logged
onto Glovia is accessing a table?
DA Morgan wrote:
> 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 - 12:26:12 CDT
