Home » SQL & PL/SQL » SQL & PL/SQL » oracle osuser name
oracle osuser name [message #187] Thu, 24 January 2002 21:01 Go to next message
Amita Kapadia
Messages: 8
Registered: January 2002
Junior Member
Hello,

How do I get MY Session id and osuser name from v$session the moment I connect to oracle db. I want to know osuser because oracle user name is used by many users. so I cannot say select username,osuser from v$session where username like 'abc' and osuser = ?. so session id or osuser name is required to use in trigger.
Re: oracle osuser name [message #188 is a reply to message #187] Fri, 25 January 2002 00:00 Go to previous messageGo to next message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Create
AFTER LOGON TRIGGER ON DATABASE or SCHEMA
Re: oracle osuser name [message #197 is a reply to message #187] Sun, 27 January 2002 10:17 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
there is one more way...

select sid,serial#,username,osuser
from v$session
where username=USER
and osuser=sys_context('USERENV','OS_USER')
Previous Topic: Re: UTL_FILE
Next Topic: a problem about oracle error ora-06508
Goto Forum:
  


Current Time: Sat Apr 04 22:43:56 CDT 2020