Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Resumable logon trigger

Resumable logon trigger

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 11 May 2006 10:07:02 -0700
Message-ID: <1147367222.872753.196130@j73g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US