DBA_ROLE_PRIVS View Shows Incorrect Value for DEFAULT_ROLE column in For Password Protected Roles

(Doc ID 2305053.1)

Last updated on SEPTEMBER 10, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.1]
Information in this document applies to any platform.


 The DBA_ROLE_PRIVS view shows "DEFAULT_ROLE column as "YES" in but in version it shows "NO" for the Password protected roles.

 However the SESSION_ROLES view always shows the correct value i.e. "no rows selected".



 The database has been upgraded from to


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms