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

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_at_iflexsolutions.com
> 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).

--
http://www.freelists.org/webpage/oracle-l