Re: Successful login via SQLPlus produces a server error

g3000 wrote:
> well I know that I dont have any ON STARTUP or ON LOGON triggers from
> this:
>
> SQL> select trigger_name, owner from dba_triggers where
> triggering_event='LOGON';
>
> no rows selected
>
> SQL> select trigger_name, owner from dba_triggers where
> triggering_event='STARTUP';
>
> no rows selected
>
> SQL>
>
> It is OBVIOUS that the user I am loggin on as (SYS as SYSDBA ) does NOT
> have the roles sams_base and sams_security granted.
>

iirc, logging on as sysdba, using the sys account, does *not* fire on logon triggers - else it would be possible to lock everybody out :)

-- 
Regards,
Frank van Bortel