Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Resumable logon trigger
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 ? Received on Thu May 11 2006 - 12:07:02 CDT