Beautifier foo is not quite enough ...

[rbrooker]

Cannot beautify this puppy ..

SELECT grantee
      ,owner
      ,table_name
      ,listagg(privilege, ',') within GROUP(ORDER BY CASE privilege
           WHEN 'SELECT' THEN
            1
           WHEN 'INSERT' THEN
            2
           WHEN 'UPDATE' THEN
            3
           WHEN 'DELETE' THEN
            4
           ELSE
            5
       END) privilege
FROM dba_tab_privs
WHERE grantee IN (SELECT role
                  FROM dba_roles
                  WHERE role LIKE 'EPTL_UAT%'
                  AND owner NOT LIKE 'EPTL_CI%')
GROUP BY grantee
        ,owner
        ,table_name
ORDER BY grantee
        ,owner
        ,table_name
        ,privilege

 

[Marco Kalter]

Analytic Functions are currently indeed not supported. This is on the list of enhancement requests.

 

[rbrooker]

ok, thank you ...