My Oracle Support Banner

Explicitly Setting the Default Role Using ALTER USER USERNAME DEFAULT ROLE - Other Roles Become NON-default. (Doc ID 3006163.1)

Last updated on MARCH 19, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.16.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Roles are being restricted in the database when explicitly setting the default role.

ALTER USER TESTUSR DEFAULT ROLE "DBA";

After running 'set role all;' the roles are returned successfully in 'select * from session_roles;'

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.