How to find List of all users that assigned a particular role in oracle database?
Ezana Answered question 03/10/2022
Below is the sample script to find oracle users that are assigned a particular role in database:
select * from dba_role_privs where granted_role = 'DBA'
Where ‘DBA’ is the role.
Ezana Answered question 03/10/2022