Oracle Database Discussions

I have created an after logon trigger that issues the alter session enable resumable statement. When I login to sqlplus and I issue the following statement I get no rows returned:

SELECT privilege
FROM dba_sys_privs
WHERE grantee = 'myUser'
AND privilege = 'RESUMABLE';

Is my trigger not firing or am I missing something?

Here is my trigger code:

CREATE OR REPLACE TRIGGER AFTER_LOGON_AC01
AFTER LOGON
ON DATABASE
BEGIN

EXECUTE IMMEDIATE 'ALTER SESSION ENABLE RESUMABLE';

EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END AFTER_LOGON_AC01;
/


Thanks!