Re: Resricting no. of sessions based on OS user.

  • From: "Gints Plivna" <gints.plivna@xxxxxxxxx>
  • To: Krishnadas.Chathamath@xxxxxxxxxxxxxxxxxx
  • Date: Tue, 12 Jun 2007 17:43:41 +0300

One option would be to create on logon trigger, get current os user
using sys_context('USERENV', 'OS_USER'), query v$session how many
connections the same osuser has and raise exception if the connection
number is too big.

Gints Plivna
http://www.gplivna.eu

2007/6/12, Krishnadas.Chathamath@xxxxxxxxxxxxxxxxxx
How can I restrict the no. of sessions connected based on osuser?

Means I want to restrict the OS user connecting more than 3 concurrent
sessions (3 sessions per OS users).
--
//www.freelists.org/webpage/oracle-l


Other related posts: