Ask the Expert

Restriction on maximum number of sessions

How can I put a restriction on the maximum number of sessions that a user can have on an Oracle8i database?

    Requires Free Membership to View

The first thing to do is to create a profile that limits the maximum number of sessions a user can have:
CREATE PROFILE user_max_sess_profile
   LIMIT session_per_user 5;
Once the profile has been created, assign this profile to the user:
ALTER USER scott PROFILE user_max_sess_profile;
There are many other options you can configure for the profile. Please look at this document for more details.

This was first published in February 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.