Re: Restrict Logins during specific hours

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, <Rajesh.Rao_at_jpmchase.com> wrote:

>
> 10.2.0.3. 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
> http://www.jpmorgan.com/pages/disclosures for disclosures relating to UK
> legal entities.
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l