Q
Problem solve Get help with specific problems with your technologies, process and projects.

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.

Dig Deeper on Oracle database design and architecture

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close