Determine user id

[huntbill]

Hi,
I'm using external password authentication to connect to oracle. The user does not enter a username and password. Is there a way to retrieve the current user name from the OracleSession object or somewhere else besides making a call to the operating system?

Thanks,Bill

 

[ThomyKay]

Hi,

you could get the os_user from db:

s_user := SYS_CONTEXT('userenv','os_user');

Originally posted by huntbill:
Hi,
I'm using external password authentication to connect to oracle. The user does not enter a username and password. Is there a way to retrieve the current user name from the OracleSession object or somewhere else besides making a call to the operating system?

Thanks,Bill

[This message has been edited by ThomyKay (edited 27 July 2001).]

 

[Marco Kalter]

Or the Oracle user:

begin :db_user := user; end;

------------------
Marco Kalter
Allround Automations