DEFAULT_ROLE for DBA shows as NO after grant to user after disabling Database Vault. OLS still shows as TRUE.
(Doc ID 2786401.1)
Last updated on JUNE 22, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
After enabling then disabling Database Vault, granting the DBA role to a user is not applied correctly.
The DEFAULT_ROLE shows as NO for DBA.
Steps to show this occurring:
1. Database Vault is enabled for the Oracle Database:
- Granting the role is fine
- However, DEFAULT_ROLE shows as NO <--- this can affect functionality.
Disabled Database Vault
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