Thanks,
Tamas
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Szecsy Tamas
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
select username, osuser from v$sesssion
Dave
-Original Message-
Sent: Tuesday, March 26, 2002 7:54 AM
To: Multiple recipients of list ORACLE-L
Hello list,
I want to know how could I identify the OS user name of a user acceding
an application. Is there any view/parameter that shows
OSUSER column in v$session view.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
The degree of normality in a database
is inversely proportional to that of its DBA.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 8:53 AM
Hello
You don't say what version of Oracle, but this function will work for 8i and
up:
SYS_CONTEXT('USERENV','OS_USER')
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday,
With a free OTN account:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
a85397/function.htm#88700
(Note: The above URL will get chopped in two pieces by MS Lookout.)
HTH!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Look at
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/function.htm#88362
JP
On Tue 26. March 2002 17:18, you wrote:
Is there a detailed list of other USERENV information taht I can have
access to by using SYS_CONTEXT?
TIA,
Tamas Szecsy
-Original