RE: Restrict login for a particular user to be only from particular machines

Sadly, I wasn't, just not thorough enough in checking out which triggers can be created. The Create Trigger section of the SQL Reference seems to indicate that Before Logon is doable. I thought it was reasonable for Before Logon to mean As-The-User-Is-Attempting-To-Logon, maybe after they enter the correct password, but before their session is completely instantiated.

However, chapter 16 "Working With System Events" in "Oracle9i Application Developer's Guide - Fundamentals" confirms that Before Logon and After Logoff can't exist.

I thought of another way to do this, simply lock the account when you don't want them to logon. It could even be automated if the user is restricted to certain hours. Looked at Profiles, but in 9i you can't set times for allowable logons. Not sure how to keep the User out if her IP address is not allowed.

Lots of options. Some of us just need to read the Subject line better and do more thorough research. ;-(

Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)

 I feel so unnecessary. -- Rufus Thomas

               ( "Do the Funky Chicken")

"Igor Neyman" <ineyman_at_perceptron.com>
09/13/2006 03:08 PM

To
<rjamya_at_gmail.com>, <paul.baumgartel_at_credit-suisse.com>
cc
<JApplewhite_at_austinisd.org>, <oracle-l_at_freelists.org>
Subject
RE: Restrict login for a particular user to be only from particul ar m achines

I think, Jack was joking...

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of rjamya
Sent: Wednesday, September 13, 2006 4:01 PM To: paul.baumgartel_at_credit-suisse.com
Cc: JApplewhite_at_austinisd.org; oracle-l_at_freelists.org Subject: Re: Restrict login for a particular user to be only from particul ar m achines

I don't think there is a before logon trigger ...

Raj

On 9/13/06, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com > wrote: Jack,  

Yes, that would do the trick nicely, wouldn't it?

Paul Baumgartel

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto: oracle-l-bounce_at_freelists.org ]On Behalf Of JApplewhite_at_austinisd.org
Sent: Wednesday, September 13, 2006 2:39 PM To: oracle-l_at_freelists.org
Subject: RE: Restrict login for a particular user to be only from particul ar m achines

Paul,

To prevent logon, shouldn't this be a Before Logon trigger?

Jack C. Applewhite - Database Administrator

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