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 -> Re: Identify which user accesses an Oracle table.

Re: Identify which user accesses an Oracle table.

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 21 Jun 2006 14:35:46 -0400
Message-ID: <lqadnXeStuoUDATZnZ2dnUVZ_oGdnZ2d@comcast.com>

"Michael B" <michaelberry_at_bellsouth.net> wrote in message news:1150910833.729104.154030_at_p79g2000cwp.googlegroups.com...
: 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?

:

ask them what package variable or function call they have that specfies their authenticated user -- that information should be available to the trigger depending on how they do session management.

bottom line is that if you can't get what you need from any of the USERENV options, then it's a Glovia issue Received on Wed Jun 21 2006 - 13:35:46 CDT

Original text of this message

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