Check for Roles Assigned to PUBLIC

select granted_role from dba_role_privs where grantee='PUBLIC';