Q

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?

How can I put a restriction on the maximum number of sessions that a user can have on an Oracle8i database?
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 last published in February 2007

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close