VIEW: DVSYS.DV_AUDIT_CLEANUP_GRANTEES

Source

View Text - Preformatted

select grantee, connect_path, admin_option
from (select grantee,
             'DV_AUDIT_CLEANUP'||SYS_CONNECT_BY_PATH(grantee, '/') connect_path,
             granted_role, admin_option
      from   sys.dba_role_privs
      where decode((select type# from sys.user$ where name = grantee),
               0, 'ROLE',
               1, 'USER') = 'USER'
      connect by nocycle granted_role = prior grantee
      start with granted_role = upper('DV_AUDIT_CLEANUP'))

View Text - HTML Formatted

SELECT GRANTEE
, CONNECT_PATH
, ADMIN_OPTION FROM (SELECT GRANTEE
, 'DV_AUDIT_CLEANUP'||SYS_CONNECT_BY_PATH(GRANTEE
, '/') CONNECT_PATH
, GRANTED_ROLE
, ADMIN_OPTION
FROM SYS.DBA_ROLE_PRIVS
WHERE DECODE((SELECT TYPE#
FROM SYS.USER$
WHERE NAME = GRANTEE)
, 0
, 'ROLE'
, 1
, 'USER') = 'USER' CONNECT BY NOCYCLE GRANTED_ROLE = PRIOR GRANTEE START WITH GRANTED_ROLE = UPPER('DV_AUDIT_CLEANUP'))