Re: Restrict login for a particular user to be only from particul ar m achines

On 9/13/06, Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com> wrote:
>
>
> However, I'm now stymied in a simple test case: the following SYS trigger
> is firing, but no error appears on login.
>

This is documented behavior.

You cannot use a trigger to prevent a DBA account from logging on.

Any logon initiated by a user that has been granted the ADMINISTER DATABASE TRIGGER privilege will bypass a logon trigger.

SYS has this privilege and can therefor logon to the database regardless of what happens in the trigger.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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