Permissions Report

Michael_Fennell

Hi Forum I am wondering if someone here can shed some light on the following issue for me.I am using a live report to traverse a folder structure and list out the groups and their assigned permissions, problem is it does not seem to be returning the correct information.What i have seen is when i run the report i check the information against the actual structure and some of the groups are just showing they have see when they actually have see, see content.this is the code i am using.SQL:SELECT DTREE.DataID, DTREE.Name, DECODE(DTREEACL.RIGHTID, -1,'Public Access', KUAF.FIRSTNAME || ' ' || KUAF.LASTNAME || ' ('|| KUAF.NAME || ')' ) "UserGroup" , ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS / 2),2) = 1 THEN 'See' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/36865),2) = 1 THEN '/See Content' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/65536),2) = 1 THEN '/Modify' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/16),2) = 1 THEN '/Edit Permissions' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/131072),2) = 1 THEN '/Edit Attributes' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/4),2) = 1 THEN '/Add Item' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/16384),2) = 1 THEN '/Delete Versions' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/8),2) = 1 THEN '/Delete' ELSE NULL END) || ( CASE WHEN mod(floor(DTREEACL.PERMISSIONS/8192),2) = 1 THEN '/Reserve' ELSE NULL END) AS RightsFROM DTREE, KUAF, DTREEACLWHERE DTREEACL.DATAID = DTREE.DATAIDAND DTREEACL.RIGHTID = KUAF.ID(+)AND DTREE.DATAID IN (SELECT DataID FROM DTree Where Subtype = 0 /* Folder type */ START WITH DataID = %1 CONNECT BY Prior DataID = ParentID)AND DTREEACL.ACLTYPE <> 1AND DTREEACL.ACLTYPE <> 2AND DTREEACL.ACLTYPE <> 4Can anyone shed any light on where i might be going wrong ?, any help would be greatly appreciated as i cannot really see what is wrong and why i am getting the incorrect values being displayed on the report.RegardsMike.