Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Restrict Logins during specific hours

Re: Restrict Logins during specific hours

From: Niall Litchfield <>
Date: Thu, 8 Nov 2007 06:34:24 +0000
Message-ID: <>

cue tacky 70s music....

This sounds like a job for ...... Resource Manager

end tacky 70s music..

it won't stop a logon, but you can prevent them interfering with real users at that time.

On Nov 8, 2007 3:59 AM, <> wrote:

> The database has a user that is used exclusively to execute
> batch jobs, using a scheduling software (either Autosys or ControlM).
> Without writing an on-logon database trigger, is there a way of preventing
> this user from logging in between say 10 AM and 11 AM? Users do not wish to
> use dbms_scheduler to schedule the jobs.
> Thanks
> Raj
> ------------------------------
> This communication is for informational purposes only. It is not intended
> as an offer or solicitation for the purchase or sale of any financial
> instrument or as an official confirmation of any transaction. All market
> prices, data and other information are not warranted as to completeness or
> accuracy and are subject to change without notice. Any comments or
> statements made herein do not necessarily reflect those of JPMorgan Chase &
> Co., its subsidiaries and affiliates. This transmission may contain
> information that is privileged, confidential, legally privileged, and/or
> exempt from disclosure under applicable law. If you are not the intended
> recipient, you are hereby notified that any disclosure, copying,
> distribution, or use of the information contained herein (including any
> reliance thereon) is STRICTLY PROHIBITED. Although this transmission and any
> attachments are believed to be free of any virus or other defect that might
> affect any computer system into which it is received and opened, it is the
> responsibility of the recipient to ensure that it is virus free and no
> responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and
> affiliates, as applicable, for any loss or damage arising in any way from
> its use. If you received this transmission in error, please immediately
> contact the sender and destroy the material in its entirety, whether in
> electronic or hard copy format. Thank you. Please refer to
> for disclosures relating to UK
> legal entities.

Niall Litchfield
Oracle DBA

Received on Thu Nov 08 2007 - 00:34:24 CST

Original text of this message