Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Regarding query

Regarding query

From: LittleDBA <mlei_at_txi.com>
Date: 2 Sep 2004 12:31:55 -0700
Message-ID: <b6ba5bb.0409021131.6e7e72ba@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 - 14:31:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US