Regarding query
From: LittleDBA <mlei_at_txi.com>
Date: 2 Sep 2004 12:31:55 -0700
Message-ID: <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')
/
Received on Thu Sep 02 2004 - 21:31:55 CEST
Date: 2 Sep 2004 12:31:55 -0700
Message-ID: <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')
/
Received on Thu Sep 02 2004 - 21:31:55 CEST