SQL Language (MOSC)

MOSC Banner

What is the difference between CURRENT_IS_ROLE_ENABLED and SESSION_IS_ROLE_ENABLED

edited Oct 8, 2020 9:21AM in SQL Language (MOSC) 2 commentsAnswered

In Oracle 19c the DBMS_SESSION package state this:

IS_ROLE_ENABLED Function

This function determines if the named role is enabled for this session.

Note:

This function is deprecated starting in Oracle Database 19c. Use DBMS_SESSION.CURRENT_IS_ROLE_ENABLED or DBMS_SESSION.SESSION_IS_ROLE_ENABLED instead.


What are the differences between these two functions? When to use which one? The documentation does not really help here:

SESSION_IS_ROLE_ENABLED: This function determines if the named role is enabled for the login user session

CURRENT_IS_ROLE_ENABLED: This function determines if the named role is currently enabled.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center