Members   Search   Help    Register    Login   Home
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: 89
Registered: May 2009
Location: INDIA
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
gentlebabu
Messages: 1398
Registered: December 2005
Location: India, Hyderabad
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: 2410
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 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.
Report message to a moderator
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: 29419
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 30 18:15:20 CST 2009

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