Current Osuser

[Behar, Rivaldi]

Title: Current Osuser





Hi,


We can know the current oracle user (the username you are using to connect 
to database) by 'select user from dual';
How to know what is the current osuser (not the list of osuser) ?


Tia.


Rivaldi

Re: Current Osuser

[K Gopalakrishnan]

SELECT USERNAME,OSUSER FROM V$SESSION


=
Have a nice day !!

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA.

__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: K Gopalakrishnan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Current Osuser

[MacGregor, Ian A.]

Title: Current Osuser



select 
sys_context('USERENV', 'OS_USER') FROM DUAL;

Ian MacGregor
Stanford Linear Accelerator 
Center
[EMAIL PROTECTED]

  -Original Message-From: Behar, Rivaldi 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, June 11, 
  2001 2:26 PMTo: Multiple recipients of list 
  ORACLE-LSubject: Current Osuser
  Hi, 
  We can know the current oracle user (the username you are 
  using to connect to database) by 'select user from 
  dual'; How to know what is the current osuser (not the 
  list of osuser) ? 
  Tia. 
  Rivaldi