Michael B wrote:
> 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
- Please DO NOT top post.
- No. Because the product is hiding that information from Oracle.
The only possibility is if the product can be configured to pass
through the user information.
--
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 - 14:33:22 CDT
