Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Identify which user accesses an Oracle table.

Identify which user accesses an Oracle table.

From: Michael B <michaelberry_at_bellsouth.net>
Date: 21 Jun 2006 08:33:47 -0700
Message-ID: <1150904027.442292.61290@b68g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US