CMU not inheriting AD groups mapped global roles
Oracle database 19.18
We have encountered an issue in our environment where our developers' global roles are not loading when they authenticate to the database using their Active Directory (AD) logins. This problem started occurring after experiencing random reboots on our domain controller.
Here are the details of the issue:
- Random domain controller reboots have been happening.
- After these reboots, developers are unable to inherit global roles mapped to their AD groups upon authentication.
- We have confirmed successful authentication via tracing using "alter system set events='trace[gdsi] disk low';," but the authorization process does not initialize the roles.
- The global roles in question have the attribute "common=yes."