Wednesday, August 17, 2011

List profile without user in oracle

Folling pl/sql script with give you List profile without user in oracle.

--List profile without user in oracle


Select distinct p.PROFILE 
from dba_profiles p, dba_users u 
where p.PROFILE  = u.PROFILE (+) and  u.USERNAME is null

No comments:

Post a Comment