Re: How can I get UNIX ID from PLSQL?

From: Aarre Heikkilä <aarre.heikkila_at_evli.fi>
Date: Wed, 09 Feb 2000 19:03:44 GMT
Message-ID: <38a1b8e0.87080656@news.evli.fi>

Try this:

column 'Sid'   			format 9999
column 'OsUser' 		             format a8
column 'User' 			format a7
Column 'U_PID'                            format A5
Column 'Program'                         format A50
 SELECT ALL 	SYS.V_$SESSION.SID,
		SYS.V_$SESSION.SERIAL#,
                           SYS.V_$PROCESS.SPID 	"U_PID",
		SYS.V_$SESSION.LOCKWAIT,
		SYS.V_$SESSION.OSUSER	"OsUser", 
		SYS.V_$SESSION.USERNAME	"User",
                          SYS.V_$SESSION.TERMINAL, 
		SYS.V_$SESSION.PROGRAM "Program",
		SYS.V_$SESSION.SADDR
               FROM
                   SYS.V_$PROCESS, SYS.V_$SESSION
               WHERE
                   SYS.V_$PROCESS.ADDR=SYS.V_$SESSION.PADDR order by

V_$SESSION.OSUSER;  SYS.V_$PROCESS.SPID is what your want.

Aarre

On Wed, 09 Feb 2000 17:53:02 GMT, Gonzalo <GSegarra_at_iname.com> wrote:

>Hi,
>I want to create a trigger that saves in the table the UNIX user that is
>updating or inserting.
>The problem is that I don´t know ho to get the UNIX id of the user.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Wed Feb 09 2000 - 13:03:44 CST