SELECT
USERNAME
FROM
dba_users
WHERE
USERNAME NOT IN
(SELECT
GRANTEE
FROM
dba_role_privs);
1) Consider a common DBA query against the data dictionary to show all users who do not have privileges that are granted by means of a role. This query runs in 18 seconds.