469,090 Members | 1,106 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Regarding query

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')
/
---------------------------------------
Jul 19 '05 #1
1 1991
ml**@txi.com (LittleDBA) wrote in
news:b6*************************@posting.google.co m:
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
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Conner | last post: by
5 posts views Thread by parwal.sandeep | last post: by
4 posts views Thread by Supreet | last post: by
13 posts views Thread by prasadmpatil | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.