Hi,
I am using Oracle 9.2.0.7 on Solaris.
I am creating the following trigger, using a SYSDBA account in a test
database;
Create or replace trigger TRIG_LOGON
after LOGON on database
Begin
execute immediate 'Grant resumable to '||user;
execute immediate 'Alter session enable resumable timeout 50400';
end;
/

For some reason, this does not appear to work.
When I log on using any user, and execute ...
select DBMS_RESUMABLE.GET_TIMEOUT from dual;
it returns -1

Now if I use any user (who has been granted the resumable system
privilege) and issue "'Alter session enable resumable timeout 50400;"
in SQL Plus, then this seems to work, as select
DBMS_RESUMABLE.GET_TIMEOUT from dual; returns 50400

What am I missing in my logon trigger ?

ok - I found an answer to my problem on Metalink.
I can remove the grant, and replace "on database" for "on <specific
user>.schema"