Re: Regarding query

mlei_at_txi.com (LittleDBA) wrote in
news:b6ba5bb.0409021131.6e7e72ba_at_posting.google.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 Received on Thu Sep 02 2004 - 20:25:42 CDT