How to list all the roles existing in Oracle database? May 22, 2023 by Tarik Got the answer : SELECT * FROM DBA_ROLES;