Home » RDBMS Server » Security » session details in v$session (oracle,10.2.0.4,solaris)
session details in v$session [message #429149] Mon, 02 November 2009 06:02 Go to next message
replicated
Messages: 31
Registered: July 2009
Member
Hi

When users(john) login to appplication using thier own credentials,the app internaly converts their seesion in to application owner's(xyz) sessions. So in V$Session it shows osuser is (john) and username(xyz).Is there a way to capture which session was started by a username.

Report message to a moderator

Re: session details in v$session [message #429159 is a reply to message #429149] Mon, 02 November 2009 06:13 Go to previous messageGo to next message
Michel Cadot
Messages: 67640
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain what you mean, this is john doesn't it? It is in osuser, doesn't it? So what do you want more?

Regards
Michel

Report message to a moderator

Re: session details in v$session [message #429202 is a reply to message #429149] Mon, 02 November 2009 09:16 Go to previous messageGo to next message
BlackSwan
Messages: 26757
Registered: January 2009
Location: SoCal
Senior Member
Is application 2 tier or 3 tier?

Report message to a moderator

Re: session details in v$session [message #430237 is a reply to message #429202] Mon, 09 November 2009 12:30 Go to previous message
konark
Messages: 24
Registered: February 2008
Location: Takhsila
Junior Member
What password authentication you are using to login to database.
Is it external/global authentcation?or password authentication?

Report message to a moderator

Previous Topic: Problem with oracle 10g (merged)
Next Topic: Creating User With same Privilages as Existing User
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 19 10:02:53 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.