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: How can I get UNIX ID from PLSQL?

Re: How can I get UNIX ID from PLSQL?

From: Gonzalo <gonzarg_at_my-deja.com>
Date: Thu, 10 Feb 2000 12:49:13 GMT
Message-ID: <87uc48$6lt$1@nnrp1.deja.com>


In article <38a1b8e0.87080656_at_news.evli.fi>,   aarre.heikkila_at_evli.fi (Aarre Heikkilä) wrote:
> 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.
> >
>

I´ve tried this, but in SYS.V_$PROCESS.SPID I get the procees ID, not the unix user ID. In the view V$SESSION I get the name of the UNIX user (V$SESSION.OSUSER) but not the ID.

Is there any way to set a variable (e.g. with the UNIX ID) when an user begins and oracle session and then get it from any procedure?

Thanks again

session, an

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 10 2000 - 06:49:13 CST

Original text of this message

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