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.

Report message to a moderator

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

Report message to a moderator

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')

Report message to a moderator

Previous Topic: Re: UTL_FILE
Next Topic: a problem about oracle error ora-06508
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 16 19:55:41 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.