match users and role
I´m trying to correlate the users and the user role. To do this, I´m querying two views: DBA_USERS to get username and status and DBA_ROLE_PRIVS to get the granted role.
In the DBA_ROLE_PRIVS I´m getting some GRANTEE (users) that not correspond with USERNAME in DBA_USERS. By example, DBA exist in DBA_ROLE_PRIVS view, but not in DBA_USERS view.
Anyone know why is this happen?
Thank you in advance.