OraFAQ Forum: Security » session details in v$session

Home » RDBMS Server » Security » session details in v$session (oracle,10.2.0.4,solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

session details in v$session [message #429149]

Mon, 02 November 2009 06:02

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

Michel Cadot
Messages: 68264
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

BlackSwan
Messages: 26766
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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Aug 18 02:46:14 CDT 2022