Tuesday, November 12, 2013

Find roles granted to users start with "X" or "T" following by any number

select grantee, GRANTED_ROLE 
from dba_role_privs 
where REGEXP_LIKE(GRANTEE, '^[X|T][0-9]+$')order by grantee;

No comments: