Ask the Expert

Restricting database logon times

How can I make a profile for a certain group of Oracle database users so that I can restrict their logon times to between 09.00 hrs and 17.00 hrs, also only on working days?

    Requires Free Membership to View

There is no profile setting to limit the logons of those profile users to a particular time of the day (or week). You'll have to set up an AFTER LOGON trigger. If the user logging on is a particular user name, and the logon time is outside of their time window, then kill the session.

For More Information


This was first published in November 2002

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: