OraFAQ Forum: Server Administration » Limit session from each clients.

Home » RDBMS Server » Server Administration » Limit session from each clients.

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

Limit session from each clients. [message #261426]

Wed, 22 August 2007 10:11

chara
Messages: 81
Registered: April 2005
Location: th

Member

Dear all,

I want to limit connection from application on each clients to not over 2 connections per clients.Is there anyway to limit connections for each clients on database level?

Pls advice.
Thanks for advance.
Chara

Report message to a moderator

Re: Limit session from each clients. [message #261430 is a reply to message #261426]

Wed, 22 August 2007 10:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

By creating an AFTER LOGON trigger

Report message to a moderator

Re: Limit session from each clients. [message #261433 is a reply to message #261426]

Wed, 22 August 2007 10:25

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can use profile and set SESSIONS_PER_USER resource.

Regards
Michel

Report message to a moderator

Re: Limit session from each clients. [message #261435 is a reply to message #261426]

Wed, 22 August 2007 10:34

chara
Messages: 81
Registered: April 2005
Location: th

Member

Thanks for your response . But I use one user for all clients.
I want to limit each clients can connect to db 2 sessions.
Is the SESSIONS_PER_USER can served these?

rdgs,
chara

Report message to a moderator

Re: Limit session from each clients. [message #261438 is a reply to message #261435]

Wed, 22 August 2007 10:45

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

No SESSIONS_PER_USER can't give any solution of your problem.
Better to use AFTER LOGON trigger and make a ckeck on that trigger using v$session view.

Cheers
Soumen

Report message to a moderator

Re: Limit session from each clients. [message #261444 is a reply to message #261435]

Wed, 22 August 2007 11:05

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

How do you make the difference between 2 clients if you use the same user?
The answer of this question determine the way you can do it.

Regards
Michel

Report message to a moderator

Previous Topic:	LRM-00109
Next Topic:	Cannot able to connect my Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 19:43:23 CDT 2024