OraFAQ Forum: Security » Identify users connecting database

Home » RDBMS Server » Security » Identify users connecting database (oracle 10g,solaris10)

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

Identify users connecting database [message #411679]

Mon, 06 July 2009 05:50

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi all,

can anybody let me know the method or query to identify front end (Application/clients ) and back end (database) users connecting to database?

Thanks in advance

Regards,

[Updated on: Mon, 06 July 2009 05:52]

Report message to a moderator

Re: Identify users connecting database [message #411686 is a reply to message #411679]

Mon, 06 July 2009 05:56

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

http://www.oracle-training.cc/oracle_tips_v$session.htm

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_2088.htm#sthref2731

[Updated on: Mon, 06 July 2009 05:56]

Report message to a moderator

Re: Identify users connecting database [message #411688 is a reply to message #411679]

Mon, 06 July 2009 05:56

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

1. sqlplus Smile

2. oem

Report message to a moderator

Re: Identify users connecting database [message #424454 is a reply to message #411679]

Fri, 02 October 2009 08:05

mohd_dba
Messages: 19
Registered: October 2009

Junior Member

There is one data dictionary view like v$session.

You can use the command like,

select username,status,machine,osuser,sid,serial# from v$session where status like '%ACTIVE%';

If you fire this query,you can check all the active users list.

Thanks,
Afroze.

Report message to a moderator

Re: Identify users connecting database [message #424455 is a reply to message #424454]

Fri, 02 October 2009 08:06

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As almost always this adds nothing to the previous posts.

Regards
Michel

Report message to a moderator

Previous Topic:	Renaming of Schema
Next Topic:	lost sys and system passwords

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 01 18:55:49 CDT 2025