RE: Disable certain users from login to database while applying = H

Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g1IDNev05907 for ; Mon, 18 Feb 2002 08:23:41 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id FAA73517; Mon, 18 Feb 2002 05:22:54 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 0041233B; Mon, 18 Feb 2002 05:03:21 -0800 Message-ID: Date: Mon, 18 Feb 2002 05:03:21 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: michaelcupp@SHONAC.com Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: michaelcupp@shonac.com Subject: RE: Disable certain users from login to database while applying H Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C1B87C.4E32718E" ------_=_NextPart_001_01C1B87C.4E32718E Content-Type: text/plain; charset="ISO-8859-1" But then how do you know what to change it back to? I'd steer away from this - head w/ the revoke create session -----Original Message----- Sent: Monday, February 18, 2002 3:53 AM To: Multiple recipients of list ORACLE-L How about changing their password for the time being. Aleem -----Original Message----- Sent: Monday, February 18, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Subject: Disable certain users from login to database while applying Human Hi Gurus, I need to disable certain users from login to database while I apply the Human Resources Patches for our Oracle HR 11i Applications. Which is the best way to do it ? Should I write on-logon trigger to disable or should I take away their privileges to logon to report/forms/sqlplus ? What about the rest of the DBA Applications administrator ? What do U guys do to solve the dead-lock problem (If my users access the HR tables while I apply the patches, I will encounter dead-lock problem) ? Please advise. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) INET: clchan@nie.edu.sg 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: abchaudhary-ho@beaconhouse.edu.pk 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). ------_=_NextPart_001_01C1B87C.4E32718E Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable RE: Disable certain users from login to database while applying = H

But then how do you know what to change it back = to? I'd steer away from this - head w/ the revoke create = session

-----Original Message-----
From: Abdul Aleem [mailto:abchaudhary-ho@= beaconhouse.edu.pk]
Sent: Monday, February 18, 2002 3:53 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Disable certain users from login to = database while applying H

How about changing their password for the time = being.

Aleem

-----Original Message-----
Sent:   Monday, February 18, 2002 12:28 = PM
To:     Multiple recipients of = list ORACLE-L
Subject:        = Disable certain users from login to database while applying
Human

Hi Gurus,

I need to disable certain users from login to = database while I apply the Human Resources Patches for our Oracle HR = 11i Applications. Which is the best way to do it ? Should I write = on-logon trigger to disable or should I take away their privileges to = logon to report/forms/sqlplus ? What about the rest of the DBA = Applications administrator ? What do U guys do to solve the dead-lock = problem (If my users access the HR tables while I apply the patches, I = will encounter dead-lock problem) ?

Please advise. Thanks.

Regds,
New Bee
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: clchan@nie.edu.sg

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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Abdul Aleem
INET: = abchaudhary-ho@beaconhouse.edu.pk

------_=_NextPart_001_01C1B87C.4E32718E-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: michaelcupp@SHONAC.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).