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