Is it possible to enable roles from after logon database trigger?
484036Sep 3 2006 — edited Sep 3 2006Is it possible to enable roles from after logon database trigger?
I am working in an application.In this application my requirement is whenever
any user login in to the database then his granted roles will be enabled.
To achieve this I have created a after logon database trigger.From this
trigger I am calling a database package procedure and after some validation
I am again calling another database package procedure to enable the roles
using dbms_session.set_role. But whenever I am trying to login
the database trigger fires and it is throwing the following error:
ORA-06565: cannot execute SET ROLE from within stored procedure
So anyone can help me with suggestion that whether it is possible
to enable role by calling a package procedure from after logon database
trigger?