RE: Disable certain users from login to database while applying H
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
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
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
> 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
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
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
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
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
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
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).