Need a report which is able to show on which folders a permission group is set.

Peter_Arens_(p_arenspe_-_(deleted))

Need a report which is able to show on which folders a permission group is set.This report is nearly necessary, if you want to put new employees into a group and you don't want to give to much permissions to several people. Has anyone written such a report?Thanks for your help.

Tim_Hunter

Peter if I understand what you are asking, this shows all objects which have permissions directly assigned to a groupid. Uncomment the line if you only want folders. Note this only shows objects with permissions directly assigned to that group, not subgroups.SELECT A.DATAID as folderid,D1.NAME as ObjectName,D1.DATAID,nvl(st.subtype, 'UNK: '||d1.subtype) as ObjType,CASE A.RIGHTIDWHEN -1 THEN 'Public Access'WHEN -2 THEN 'System Administrators' ELSE 'Group ID: ' ||A.RIGHTID END as privsassignedto,(CASE WHEN mod(floor(A.PERMISSIONS / 2),2) = 1 then 'S' else null end)||(CASE WHEN mod(floor(A.PERMISSIONS/36865),2) = 1 then '/SC' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/65536),2) = 1 then '/M' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/16),2) = 1 then '/EP' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/131072),2) = 1 then '/EA' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/4),2) = 1 then '/AI' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/16384),2) = 1 then '/DV' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/8),2) = 1 then '/D' else null END)||(CASE WHEN mod(floor(A.PERMISSIONS/8192),2) = 1 then '/R' else null END)as PERMISSIONS,K.NAME as GroupNameFROM DTREE D1, DTREEACL A, KUAF K ,ll_subtypes stWHERE A.DATAID = D1.DATAID /* AND D1.SUBTYPE = 0 -- FOLDERS ARE 0 */AND D1.subtype = st.id(+)AND K.ID = A.RIGHTID AND A.RIGHTID IN (%1)ORDER BY K.NAME, D1.NAME