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

2002-02-20 Thread CHAN Chor Ling Catherine (CSC)

Hi Hemant,

Thanks for your earlier reply. 

I will not lock APPS, APPLSYS and APPLSYSPUB accounts as these accounts are
needed for the HR patches. 

In my company, we do have in-house applications which use client-server
forms/reports to access (read-only privilege) the HR tables. We created user
accounts for these applications. The last time when I applied HR patches, I
encountered deadlock despite shutting down the concurrent manager, forms
server, report server , apache server, web db 2.5 server etc.  I suspected
some of my users were accessing the HR tables via sqlplus/client-server
forms/reports, thereby causing deadlocks.

This time round, I will lock the user accounts which use client-server
forms/reports to access (read-only privilege) the HR tables. 

Hope it helps. 

Regds,
Catherine
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, February 20, 2002 4:44 PM
To: CHAN Chor Ling Catherine (CSC)
Cc: [EMAIL PROTECTED]
Subject:RE: Disable certain users from login to
database while applying H


Catherine

Which database accounts will you lock ?  You can't lock
APPS, APPLSYS and
APPLSYSPUB
as APPLSYSPUB and APPS will be used by all users and APPS
and APPLSYS will
be used by the patch.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
19/02/2002 05:23 PM
Sent by: [EMAIL PROTECTED]




Hi Gurus,

Thanks for replying to my qn.

"Startup Database in Restricted mode" will not work (for
more details, pls
refer to the email below).

The following solutions :
1.  Database ON LOGON Trigger => don't know whether it will
work
2.  Lock Database Account => I am going to use this
solution.
3.  Change Database Account Password => I believe it will
work

In our Oracle HR, we also support oracle client-server
forms/reports, so
I've to disable their accounts so that they do not access
the HR database
using sqlplus/forms/reports while I am applying patches.


Regds,
Catherine
 -Original Message-
 From:
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
 Sent:  Tuesday, February 19,
2002 2:13 PM
 To:   Multiple recipients of list
ORACLE-L
 Subject:   Re: Disable certain
users from login to
database while applying Human


 As you are talking of Oracle Apps, NONE
of the
suggested
solutions :
 1.  Database ON LOGON Trigger
 2.  Lock Database Account
 3.  Change Database Account Password
 4.  Startup Database in Restricted mode
 would work.

 The users connect to the Database in
the APPS schema
-- this
is the
 "universal"
 schema that Oracle Apps uses.  The
Patch requires APPS
so
Restricted
 doesn't
 help (unless you grant Restricted to
APPS in which
case all
the users can
 logon).
 Ditto about locking, changing password
or writing a
trigger
on the APPS
 schema.

 What you can do are :
 1. Shutdown the Apache server for the
Self-Service
Modules
 2. Shutdown the Forms server for the
Forms Module
 3. Shutdown the Concurrent Managers.

 All of the above would affect ALL
users.

 Alternatively, login to the Application
as the System
Administrator user
 and
 change the Application User Passwords
for the users
whom you
want disabled.
  

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

2002-02-20 Thread hemantchitale


Catherine

Which database accounts will you lock ?  You can't lock APPS, APPLSYS and
APPLSYSPUB
as APPLSYSPUB and APPS will be used by all users and APPS and APPLSYS will
be used by the patch.

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>19/02/2002 05:23 PM
Sent by: [EMAIL PROTECTED]




Hi Gurus,

Thanks for replying to my qn.

"Startup Database in Restricted mode" will not work (for more details, pls
refer to the email below).

The following solutions :
1.  Database ON LOGON Trigger => don't know whether it will work
2.  Lock Database Account => I am going to use this solution.
3.  Change Database Account Password => I believe it will work

In our Oracle HR, we also support oracle client-server forms/reports, so
I've to disable their accounts so that they do not access the HR database
using sqlplus/forms/reports while I am applying patches.


Regds,
Catherine
 -Original Message-
 From:  [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
 Sent:  Tuesday, February 19, 2002 2:13 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:   Re: Disable certain users from login to
database while applying Human


 As you are talking of Oracle Apps, NONE of the
suggested
solutions :
 1.  Database ON LOGON Trigger
 2.  Lock Database Account
 3.  Change Database Account Password
 4.  Startup Database in Restricted mode
 would work.

 The users connect to the Database in the APPS schema
-- this
is the
 "universal"
 schema that Oracle Apps uses.  The Patch requires APPS
so
Restricted
 doesn't
 help (unless you grant Restricted to APPS in which
case all
the users can
 logon).
 Ditto about locking, changing password or writing a
trigger
on the APPS
 schema.

 What you can do are :
 1. Shutdown the Apache server for the Self-Service
Modules
 2. Shutdown the Forms server for the Forms Module
 3. Shutdown the Concurrent Managers.

 All of the above would affect ALL users.

 Alternatively, login to the Application as the System
Administrator user
 and
 change the Application User Passwords for the users
whom you
want disabled.
 Change the passwords back to a default (WELCOME)
later.

 However, what you SHOULD do, per Oracle Support, is 1.
Shutdown 2. Shutdown
 3. Shutdown
 as I have listed above.
 If you are familiar with Oracle Applications Patching
and
are comfortable
 with reading
 the Patch drivers, you can figure out what database
objects
are being
 modified/updated/created
 and what Forms/Reports/HTML etc files are being
modified/created by the
 patch.
 Then you can take an intelligent decision  should
you
allow users to
 logon when
 applying the patch ?

 Hemant K Chitale
 Principal DBA
 Chartered Semiconductor Manufacturing Ltd


 "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
18/02/2002 03:28 PM
 Sent by: [EMAIL PROTECTED]

 Please respond to ORACLE-L


  To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
  cc: (bcc: CHITALE Hemant
Krishnarao/IT/CHRT/ST
Group)
  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
 --
 Ple

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

2002-02-19 Thread CHAN Chor Ling Catherine (CSC)

Hi Nikunj,

Thanks for replying but I cannot stop the database listener as I need to
login to certain accounts to apply the HR patches.
I will solve the problem by locking those user accounts who could use
sqlplus/forms/reports to access my HR tables, thereby causing deadlock when
I apply the patches. Thanks.

Regds,
Catherine
-Original Message-
From:   Nikunj Gupta [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, February 20, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Disable certain users from login to
database while applying Human

stop the listener.



Make a FREE long distance call from your PC!
http://www.eboom.com/free/
- Original Message -
To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
Sent: Monday, February 18, 2002 01:23 PM
Human


> Pick One..
>
> 1. Change the password.. and then reset to original.
> 2. Revoke CREATE SESSION from user.
> 3. Startup database in Restrict mode.
>
> Hope this helps..
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
<[EMAIL PROTECTED]>
> Sent: Sunday, February 17, 2002 11:28 PM
>
>
> > 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: [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).
> >
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: Nikunj Gupta
>   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).
>
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nikunj Gupta
  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

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

2002-02-19 Thread Jared . Still

> 1.  Database ON LOGON Trigger => don't know whether it will work

Have you tried this? 

It absolutely will work, and would be easier to use and administer.

Jared






"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
02/19/02 01:23 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
    cc: 
    Subject:    RE: Disable certain users from login to database while 
applying H


Hi Gurus,

Thanks for replying to my qn.

"Startup Database in Restricted mode" will not work (for more details, pls
refer to the email below).

The following solutions :
1.  Database ON LOGON Trigger => don't know whether it will work
2.  Lock Database Account => I am going to use this solution.
3.  Change Database Account Password => I believe it will work

In our Oracle HR, we also support oracle client-server forms/reports, so
I've to disable their accounts so that they do not access the HR database
using sqlplus/forms/reports while I am applying patches.


Regds,
Catherine
 -Original Message-
 From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
 Sent:   Tuesday, February 19, 
2002 2:13 PM
 To: Multiple recipients of 
list ORACLE-L
 Subject:Re: Disable 
certain users from login to
database while applying Human


 As you are talking of Oracle Apps, NONE 
of the suggested
solutions :
 1.  Database ON LOGON Trigger
 2.  Lock Database Account
 3.  Change Database Account Password
 4.  Startup Database in Restricted mode
 would work.

 The users connect to the Database in the 
APPS schema -- this
is the
 "universal"
 schema that Oracle Apps uses.  The Patch 
requires APPS so
Restricted
 doesn't
 help (unless you grant Restricted to APPS 
in which case all
the users can
 logon).
 Ditto about locking, changing password or 
writing a trigger
on the APPS
 schema.

 What you can do are :
 1. Shutdown the Apache server for the 
Self-Service Modules
 2. Shutdown the Forms server for the 
Forms Module
 3. Shutdown the Concurrent Managers.

 All of the above would affect ALL users.

 Alternatively, login to the Application 
as the System
Administrator user
 and
 change the Application User Passwords for 
the users whom you
want disabled.
 Change the passwords back to a default 
(WELCOME) later.

 However, what you SHOULD do, per Oracle 
Support, is 1.
Shutdown 2. Shutdown
 3. Shutdown
 as I have listed above.
 If you are familiar with Oracle 
Applications Patching and
are comfortable
 with reading
 the Patch drivers, you can figure out 
what database objects
are being
 modified/updated/created
 and what Forms/Reports/HTML etc files are 
being
modified/created by the
 patch.
 Then you can take an intelligent decision 
 should you
allow users to
 logon when
 applying the patch ?

 Hemant K Chitale
 Principal DBA
 Chartered Semiconductor Manufacturing Ltd


 "CHAN Chor Ling Catherine (CSC)" 
<[EMAIL PROTECTED]>
18/02/2002 03:28 PM
 Sent by: [EMAIL PROTECTED]

 Please respond to ORACLE-L
 

  To: Multiple recipients of 
list ORACLE-L
<[EMAIL PROTECTED]> 
  cc: (bcc: CHITALE Hemant 
Krishnarao/IT/CHRT/ST
Group) 
  Subject: Disable certain 
users from login to
database while applying 
  

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

2002-02-19 Thread CHAN Chor Ling Catherine (CSC)

Hi Gurus,

Thanks for replying to my qn.

"Startup Database in Restricted mode" will not work (for more details, pls
refer to the email below).

The following solutions :
1.  Database ON LOGON Trigger => don't know whether it will work
2.  Lock Database Account => I am going to use this solution.
3.  Change Database Account Password => I believe it will work

In our Oracle HR, we also support oracle client-server forms/reports, so
I've to disable their accounts so that they do not access the HR database
using sqlplus/forms/reports while I am applying patches.


Regds,
Catherine
-Original Message-
From:   [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent:   Tuesday, February 19, 2002 2:13 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Disable certain users from login to
database while applying Human


As you are talking of Oracle Apps, NONE of the suggested
solutions :
1.  Database ON LOGON Trigger
2.  Lock Database Account
3.  Change Database Account Password
4.  Startup Database in Restricted mode
would work.

The users connect to the Database in the APPS schema -- this
is the
"universal"
schema that Oracle Apps uses.  The Patch requires APPS so
Restricted
doesn't
help (unless you grant Restricted to APPS in which case all
the users can
logon).
Ditto about locking, changing password or writing a trigger
on the APPS
schema.

What you can do are :
1. Shutdown the Apache server for the Self-Service Modules
2. Shutdown the Forms server for the Forms Module
3. Shutdown the Concurrent Managers.

All of the above would affect ALL users.

Alternatively, login to the Application as the System
Administrator user
and
change the Application User Passwords for the users whom you
want disabled.
Change the passwords back to a default (WELCOME) later.

However, what you SHOULD do, per Oracle Support, is 1.
Shutdown 2. Shutdown
3. Shutdown
as I have listed above.
If you are familiar with Oracle Applications Patching and
are comfortable
with reading
the Patch drivers, you can figure out what database objects
are being
modified/updated/created
and what Forms/Reports/HTML etc files are being
modified/created by the
patch.
Then you can take an intelligent decision  should you
allow users to
logon when
applying the patch ?

Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd


"CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]>
18/02/2002 03:28 PM
Sent by: [EMAIL PROTECTED]

Please respond to ORACLE-L


 To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>   
 cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) 
 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: [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 o

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

2002-02-18 Thread Jeff Hyde
Title: RE: Disable certain users from login to database while applying H



Try 
getting the original password values for the users concerned from dba_users - 
make an exact copy of the "values" field for each user. 
 
Now 
change the password for the users concerned.
 
When 
you want to re-establish the original password use:-
 
alter 
user  identified by values 'put original values string here' 
(remember to use the quotes).
 
This 
will reset the original password without you having to know what it 
was.
 
Jeff
 

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]On Behalf Of 
  [EMAIL PROTECTED]Sent: Monday, February 18, 2002 
  01:03To: Multiple recipients of list ORACLE-LSubject: 
  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:[EMAIL PROTECTED]] 
  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: [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).
  -- Please see the official ORACLE-L 
  FAQ: http://www.orafaq.com -- 
  Author: Abdul Aleem   
  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).


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

2002-02-18 Thread Szecsy Tamas
Title: RE: Disable certain users from login to database while applying H



I 
agree with using the revoke session solution.
 
All 
the same you can change a user's password to something else and change it back 
again without ever knowing what it was:
 
1. 
select 'alter user scott identified by values '''||password||''';' 
    
from 
dba_users    
where username = 'SCOTT';
  
put away the result
 
2. 
change the password to something else
 
3. 
change the password back again to what it was previously:
 
   execute the result of the first 
point.
 
Regards,
Tamas 
Szecsy

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, February 18, 2002 
  14:03To: Multiple recipients of list ORACLE-LSubject: 
  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 



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

2002-02-18 Thread michaelcupp
Title: 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:[EMAIL PROTECTED]] 
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: [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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  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).




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

2002-02-18 Thread Arslan Dar
Title: RE: Disable certain users from login to database while applying H





Alter user  Account Lock;
This statement will lock their accounts,


And the next time the locked user tries to login, it will get following error


ORA-28000: the account is locked



Hope this helps,


Arslan Zaheer Dar
[EMAIL PROTECTED]
Database Administrator
Shaukat Khanum Memorial Cancer Hospital & Research Centre
www.shaukatkhanum.org.pk



-Original Message-
From: Abdul Aleem [mailto:[EMAIL PROTECTED]] 
Sent: Monday, February 18, 2002 1:53 PM
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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  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).





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

2002-02-18 Thread Abdul Aleem

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: [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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  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).