Regarding query

[LittleDBA]

Could anyone tell me what this query means?
Thanks a lot.

---------------------------------------
select username
from dba_users
where not exists (select 1
from dba_role_privs
where username = grantee
and granted_role = 'DR_ACCESS')
/
---------------------------------------

[Ana C. Dent]

Re: Regarding query

mlei@txi.com (LittleDBA) wrote in
news:b6ba5bb.04 09021131.6e7e72 ba@posting.goog le.com:

Could anyone tell me what this query means?
Thanks a lot.
>
---------------------------------------
select username
from dba_users
where not exists (select 1
from dba_role_privs
where username = grantee
and granted_role = 'DR_ACCESS')
/
---------------------------------------
>

It produces a list of usernames which do not have the DR_ACCESS role