Re: Regarding query
From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 03 Sep 2004 01:25:42 GMT
Message-ID: <Xns9558BB7759F0CSunnySD_at_68.6.19.6>
Date: Fri, 03 Sep 2004 01:25:42 GMT
Message-ID: <Xns9558BB7759F0CSunnySD_at_68.6.19.6>
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 Fri Sep 03 2004 - 03:25:42 CEST