I see the list is different when queried list roles and system_auth.roles
What is the difference between LIST ROLES output and the system_auth.roles table?
@vijayshanker.oracle_94842 The LIST ROLES command displays the roles that the current authenticated role has permissions to display. For example, a non-superuser role will only be able to list a limited set of roles since it doesn't have permissions to view superuser roles.
On the other hand, typically only superuser roles can view the contents of the system_auth.roles table unless other roles have been granted SELECT permissions. Cheers!
3 People are following this question.
