Limit max no of user [message #175777] |
Mon, 05 June 2006 05:56 |
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 |
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.
|
|
|