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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: