List All Users and Roles From An Oracle Database

The following sql queries will return all users and roles of a oracle database.

List All Users Query

select * from all_users

List All Roles Query

select * from dba_roles