Home » RDBMS Server » Server Administration » Limit max no of user
Limit max no of user [message #175777] Mon, 05 June 2006 05:56 Go to next message
papu
Messages: 27
Registered: March 2005
Location: Dhaka
Junior Member

hello all

i need to limit max concurrent users in a database. what will be the command in init.ora file. explain plz

regards

papu
Re: Limit max no of user [message #175783 is a reply to message #175777] Mon, 05 June 2006 06:32 Go to previous message
aciolac
Messages: 242
Registered: February 2006
Senior Member
As I understand, You want to set up maximul number of allowed connections. For making this, it is not necessary to make something in init.ora, but to change profile settings. In every database there are exist DEFAULT profile. You must to set for him a maximum number of allowed connections. If Your users use profile other than DEFAULT, then set for his profile maximum number of connexions to default - in this case maximum number of connexions for this profile will be such number as for DEFAULT profile.
Previous Topic: list partitioning error
Next Topic: Import problem. need help
Goto Forum:
  


Current Time: Fri Sep 20 12:30:46 CDT 2024