After logon trigger behaviour

Hello,

I have a problem with an after logon trigger. The purpose of the trigger is to block connexions from two servers if the user has more than CREATE SESSION and SELECT privileges.

In this trigger, I use a SQL request on user_role_privs, user_system_privs, user_tab_privs and user_col_privs. This request works fine when I run it in a PL/SQL block for a user but it failed when included in the trigger (see code below).

Here's the code of the trigger:

CREATE OR REPLACE TRIGGER "SYS"."RESTRICT_ACCESS_LOGON_TRIGGER" AFTER LOGON ON DATABASE