Actually, if you reverse the order, they won't be able to log back in after you kill their sessions.
Jared On Sunday 30 December 2001 23:40, [EMAIL PROTECTED] wrote: > Hi, > > After you've kicked them out already you can also do an alter system enable > restricted session. (no need to shut it down if for instance batch jobs are > already running) > This will allow anybody with restricted session privileges to connect to > the database (DBA role has it included). > > > Jack > > > > > Stephane Faroult <[EMAIL PROTECTED]>@fatcity.com on 29-12-2001 16:55:17 > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > > Ken Janusz wrote: > > Will shutdown normal allow me access the DB as SYS or SYSTEM while > > keeping > > > the regular users out? Or, is there a better way of doing this? > > > > Thanks, > > Ken > > shutdown normal? Never using it. If you really want to keep users out > you must first kick out those who are connected. Use shutdown immediate > or (slightly less fascistic) shutdown transactional, then restart your > database using startup restrict. Nobody will annoy you. > -- > Regards, > > Stephane Faroult > Oriole Ltd > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephane Faroult > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > > > > > =================================================================== > De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor > de geadresseerde. Gebruik van deze informatie door anderen dan de > geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding > en/of verstrekking van deze informatie aan derden is niet toegestaan. > Ernst & Young staat niet in voor de juiste en volledige overbrenging van de > inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. > =================================================================== > The information contained in this communication is confidential and may be > legally privileged. It is intended solely for the use of the individual or > entity to whom it is addressed and others authorised to receive it. If you > are not the intended recipient you are hereby notified that any disclosure, > copying, distribution or taking any action in reliance on the contents of > this information is strictly prohibited and may be unlawful. Ernst & > Young is neither liable for the proper and complete transmission of the > information contained in this communication nor for any delay in its > receipt. > =================================================================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).