I don't think there is a before logon trigger ...
Raj
Jack,
Yes, that would do the trick nicely, wouldn't it?
*Paul Baumgartel* *CREDIT SUISSE* Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com
-----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 Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)
I feel so unnecessary. -- Rufus Thomas ( "Do the Funky Chicken")
*"Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>* Sent by: oracle-l-bounce@xxxxxxxxxxxxx
09/13/2006 01:24 PM Please respond to paul.baumgartel@xxxxxxxxxxxxxxxxx
To "'Bobak, Mark'" <Mark.Bobak@xxxxxxxxxxxxxxx>, salem.ghassan@xxxxxxxxx cc oracle-l@xxxxxxxxxxxxx Subject RE: Restrict login for a particular user to be only from particul ar m achines
Thanks for all the replies. My initial attempts used an AFTER LOGON ON SCHEMA, not DATABASE, trigger.
However, I'm now stymied in a simple test case: the following SYS trigger is firing, but no error appears on login.
create or replace trigger verify_client after logon on database when (user='PB') begin insert into pb.foo values('Test'); commit; raise_application_error(-20999,'Not authorized'); end; / Here's what happens:
SQL> @conn pb/pb Connected. PB@xxxxxxxxxxxxxxxx> select * from foo;
BAR -------------------- Test
PB@xxxxxxxxxxxxxxxx> @conn pb/pb Connected. PB@xxxxxxxxxxxxxxxx> select * from foo;
BAR -------------------- Test Test
As you can probably guess, I added the "insert into pb.foo" to the trigger to verify that it is firing. What's wrong here?
Thanks
*Paul Baumgartel* * CREDIT SUISSE* Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com
============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer:
http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==============================================================================
-- ---------------------------------------------- Got RAC?