| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Preventing user access
Sean:
Although probably you won't use it right now but in Oracle 9i there is a new function called "Quiesce the database" which will put the database into a partially available state. During this time, no ongoing non-DBA transactions, queries, or PL/SQL statements are allowed. Several maintenance operations could benefit from this feature.
SQL> Alter SYSTEM QUIESCE RESTRICTED;
Kevin
-----Original Message-----
Sean
Sent: Wednesday, September 26, 2001 7:25 AM
To: Multiple recipients of list ORACLE-L
If I wish to do work on a database logging in to server itself and want to prevent users from accessing the system via network is there another way to do this if I don't want to use the "enable restricted session" functionality. I'm thinking there's probably a neat way to utiltise the listener process but have not figured it out.
Also what If I need to work on DB over network but don't want any other users using DB what can I do to prevent their connecting?
Sean :)
Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA ---> End 2002 deadline =:-O
[0%] OCP Oracle9i DBA
-------------------------------- ------------Organon (Ireland) Ltd.
Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
"Nobody loves me but my mother... and she could be jivin' too." - BB King
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: Sean.ONeill_at_organon.ie 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_at_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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Tsay INET: ktsay_at_sitesmith.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_at_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).Received on Wed Sep 26 2001 - 15:48:28 CDT
 |
 |