Retrieving User Role Privileges in Oracle SQL Code 1select grantee 2, granted_role 3, admin_option 4from dba_role_privs 5where grantee like upper('&username') 6/ Sample Oracle Output: 1 2no rows selected 3SQL> Purpose: This code retrieves the roles granted to a specific user, indicating whether each role …