Message-Id: <10543.110823@fatcity.com> From: "Mike Lanteigne" Date: Thu, 29 Jun 2000 15:59:22 -0500 Subject: Re: Limiting a specific user connections to enable resource limits set in profiles... 1 set 'resource_limit = true' in the init.ora file and bounce the instance or 2 in a session type 'alter system set resource_limit = true' Must have alter system privs. HTH Mike ----- Original Message ----- From: "Olson, David" To: "Multiple recipients of list ORACLE-L" Sent: Thursday, June 29, 2000 1:48 PM Subject: Limiting a specific user connections > DBA's, > > What is the best way of limiting the number of connections that a specific > user can have. I have tried setting up a profile, but it doesn't stop the > user from connecting to the db. > > Thanks, > Dave > > Dave Olson > DBA - Tech. Support Team > 216-332-3195 > > > -- > Author: Olson, David > INET: OlsonD@PIOS.COM > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing).