group having permissions on folders

is it possible to get a list of folders where a particular groups has access to?

Find more posts tagged with

Comments

This should give you what you want.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 A.ACLTYPE = 0 *//* 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

Evert_Kuiken_(ekuiken_-_(deleted))

This report does not work on our database (Oracle) because the ll_subtypes table is unknown. Can you help me out? What table is that?

Tim_Hunter

I assumed it was a standard table, not sure what created it. However its not important to the overall query, see the new query below. SELECT A.DATAID as folderid,D1.NAME as ObjectName,D1.DATAID,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 WHERE A.DATAID = D1.DATAID /* AND A.ACLTYPE = 0 *//* AND D1.SUBTYPE = 0 -- FOLDERS ARE 0 */AND K.ID = A.RIGHTID AND A.RIGHTID IN (724585)ORDER BY K.NAME, D1.NAME