Regarding query

#1

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')
/
---------------------------------------

#2

mlei (AT) txi (DOT) com (LittleDBA) wrote in
news:b6ba5bb.0409021131.6e7e72ba (AT) posting (DOT) google.com:

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Regarding query

comp.databases.oracle comp.databases.oracle

Regarding query - 09-02-2004 , 02:31 PM

Re: Regarding query - 09-02-2004 , 08:25 PM