RE: Restrict login for a particular user to be only from particular machines
- From: JApplewhite@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 13 Sep 2006 15:26:00 -0500
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@xxxxxxxxxxxxxx>
09/13/2006 03:08 PM
To
<rjamya@xxxxxxxxx>, <paul.baumgartel@xxxxxxxxxxxxxxxxx>
cc
<JApplewhite@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of rjamya
Sent: Wednesday, September 13, 2006 4:01 PM
To: paul.baumgartel@xxxxxxxxxxxxxxxxx
Cc: JApplewhite@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxx > wrote:
Jack,
Yes, that would do the trick nicely, wouldn't it?
Paul Baumgartel
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto: oracle-l-bounce@xxxxxxxxxxxxx
]On Behalf Of JApplewhite@xxxxxxxxxxxxx
Sent: Wednesday, September 13, 2006 2:39 PM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
- » RE: Restrict login for a particular user to be only from particular machines
