Re: Identifying logged in users

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 12 Jun 2002 07:08:30 +0200
Message-ID: <holdgu47ep71nlgc5sqcl5c7oel9kmgivv@4ax.com>

On 11 Jun 2002 20:32:28 -0700, nmangalath_at_hotmail.com (Naru Mangalath) wrote:

>Hi,
>I am an Oracle DBA managing a 11i Financials database. I do have
>Oracle DBMS experience, but not much of Financials. When I look at
>v$session for currently logged in users all the users appear as
>follows:
>Oracle user:APPS
>OS user: FINTEST
>
>How can I get information about the real logged in user names?
>Thanks for any help.
>
>Naru Mangalath

Check out the columns OSUSER and TERMINAL and/or do a describe of v$sessions or a select * from dict_columns where table_name = 'V$SESSIONS' Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jun 12 2002 - 00:08:30 CDT