Sessions per user within dba_profiles. Either create a new profile (recommended) and alter the default profile alter profile new_profile limit sessions per user 3 (or something very similar) If you really needed to do it at an os level then can it be changed at the os level itself or write a logon trigger that checks v$session for the os$user and does a count John ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Krishnadas.Chathamath@xxxxxxxxxxxxxxxxxx Sent: 12 June 2007 14:21 To: oracle-l@xxxxxxxxxxxxx Subject: Resricting no. of sessions based on OS user. Hi, 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). Thanks & Regards Kris