Members   Search   Help    Register    Login   Home
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: 20
Registered: July 2009
Junior 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: 29434
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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: 3359
Registered: January 2009
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 Dec 1 04:01:55 CST 2009

Total time taken to generate the page: 1.00413 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.