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

Home -> Community -> Usenet -> c.d.o.tools -> Getting Current User from triggers

Getting Current User from triggers

From: Fabio GRANDE <fabiog_at_fileita.it>
Date: Mon, 16 Jul 2001 17:30:03 +0200
Message-ID: <9iv0c1$s46$1@fe2.cs.interbusiness.it> 






Hi all !


I have a trigger attached to a table, that run every time there's an insert
or an update.


In this trigger, I need to know the current Oracle User (and other info such
as those I can get from v$session view such as OSUSER and MACHINE).
Is there a way to do this with PL/SQL ?


Thanx in advance for Your co-operation


--
Fabio GRANDE
fabiog_at_NOSPAMfileita.it


Received on Mon Jul 16 2001 - 10:30:03 CDT












Original text of this message













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