Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possible to enable roles from after logon database trigger?

484036Sep 3 2006 — edited Oct 10 2006

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2006

Added on Sep 3 2006

#database-security, #database-security-general

1 comment

4,039 views