I am trying to get Os_User name with this Sql Statement, but it give me error i m user "<b>Oracle8i Enterprise Edition Release 8.1.5.0.0</b>"
SQL> SELECT sys_context('USERENV', 'OS_USER') FROM dual;
SELECT sys_context('USERENV', 'OS_USER') FROM dual
*
ERROR at line 1:
ORA-02003: invalid USERENV parameter
is any other way to get Os_User?? except this one????
<b>select osUser from v$Session
where UserName = User
and status = 'ACTIVE';</b>
Thanks in advance
take care
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Problem with Sys_Context
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Who is online
Users browsing this forum: No registered users and 1 guest