SELECT Permissions = CASE Permissions ��
WHEN '128' THEN 'No Permissions' �
WHEN '130' THEN 'See' �
WHEN '36995' THEN 'See, See Content' �
WHEN '65666' THEN 'See, Modify' �
WHEN '65670' THEN 'See, Modify, Add Items' �
WHEN '102531' THEN 'See, See Content, Modify' �
WHEN '102535' THEN 'See, See Content, Modify, Add Items' �
WHEN '102547' THEN 'See, See Content, Modify, �Edit permissions' �
WHEN '102551' THEN 'See, See Content, Modify, �Edit permissions, Add Items' �
WHEN '118915' �THEN 'See, See Content, Modify, Delete versions' �
WHEN '118919' �THEN 'See, See Content, Modify, Add Items, Delete versions'�
WHEN '118923' THEN 'See, See Content, Modify, Delete versions, Delete'�
WHEN '118927' THEN 'See, See Content, Modify, Add Items, Delete versions, Delete'�
WHEN '118931' THEN 'See, See Content, Modify, �Edit permissions, Delete versions'�
WHEN '118939' THEN 'See, See Content, Modify, �Edit permissions, Delete versions, Delete'�
WHEN '127107' THEN 'See, See Content, Modify, �Delete versions, Reserve'�
WHEN '127111' THEN 'See, See Content, Modify, �Add Items, Delete versions, Reserve'�
WHEN '127115' THEN 'See, See Content, Modify, �Delete versions, Delete, Reserve'�
WHEN '127119' THEN 'See, See Content, Modify, �Add Items, Delete versions, Delete, Reserve'�
WHEN '127123' THEN 'See, See Content, Modify, Edit permissions, Delete versions, Reserve'�
WHEN '127131' THEN 'See, See Content, Modify, Edit permissions, Delete versions, Delete, Reserve'�
WHEN '233603' THEN 'See, See Content, Modify, Edit attributes'�
WHEN '233607' THEN 'See, See Content, Modify, Edit attributes, Add Items'�
WHEN '233619' THEN 'See, See Content, Modify, Edit permissions, Edit attributes'�
WHEN '249987' THEN 'See, See Content, Modify, Edit attributes, Delete versions'�
WHEN '249995' THEN 'See, See Content, Modify, Edit attributes, Delete versions, Delete'�
WHEN '258179' THEN 'See, See Content, Modify, Edit attributes, Delete versions, Reserve' �
WHEN '258187' THEN 'See, See Content, Modify, Edit attributes, Delete versions, Delete, Reserve' �
WHEN '16777215' THEN 'Administrator Rights' �
END FROM DtreeACL , Dtree �
WHERE Dtree.DataID = DtreeACL.DataID �
AND Dtree.Subtype=0 �
AND DtreeACL.DataID = %1 �
AND DtreeACL.RightID = %2�
