Home » RDBMS Server » Security » Identify users connecting database (oracle 10g,solaris10)
Identify users connecting database [message #411679] Mon, 06 July 2009 05:50 Go to next message
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 Go to previous messageGo to next message
babuknb
Messages: 1734
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 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

1. sqlplus Smile
2. oem
Re: Identify users connecting database [message #424454 is a reply to message #411679] Fri, 02 October 2009 08:05 Go to previous messageGo to next message
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.
Re: Identify users connecting database [message #424455 is a reply to message #424454] Fri, 02 October 2009 08:06 Go to previous message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As almost always this adds nothing to the previous posts.

Regards
Michel
Previous Topic: Renaming of Schema
Next Topic: lost sys and system passwords
Goto Forum:
  


Current Time: Sun Dec 21 16:40:34 CST 2014

Total time taken to generate the page: 0.08102 seconds