LiveReport for document permissions different than parent folder

Someone has come to me to with a tall order. They would like me to create a report that displays documents with permissions that are different from the parent folder. They also wanted the report formatted so it displays the full path to the document, document name, user name, and permission level. Any help would be greatly appreciated.Thanks!

Find more posts tagged with

Comments

Tim_Hunter

This is certainly going to be a tough one, each object has multiple rows in the dtreeacl table. I can't think of a good way to compare a set of rows in the dtreeacl table for one object to a set for another object. If someone can give me that knowledge I could probably work something up.A starter query to get all permissions on an object and all subobjects:SELECT DTREEACL.DATAID as objectid,DTree_1.Name AS objectlocation,DTree.Name AS objectname,DTREEACL.RIGHTID,DTreeACL.PermissionsFROM DTreeACL INNER JOIN DTree ON DTreeACL.DataID = DTree.DataID INNER JOIN DTree DTree_1 ON DTree.ParentID = DTree_1.DataID WHERE (DTreeACL.ACLType = 0) AND (DTreeACL.ParentID <> - 1) AND (DTreeACL.Permissions <> 128) and DTree.ParentID = %1ORDER BY DTree_1.Name, DTree.Name

Evert_Kuiken_(ekuiken_-_(deleted))

Message from <Evert.Kuiken@alliander.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Hi Jeremy,

Although you for sure can do this using LiveReports, I would like to draw your attention to a module we use that was developed by Logica. It allows you (and users you give the proper permissions) to create a listing of all permissions of a given folder (and subfolders), showing differences with the parent object etc. It can export the report to Excel as well. You also have the ability to change the permissions so that they are identical to the parent object. If you want I can get you in contact with someone from Logica. Open Text has a similar custom module which however has less functionality. Also BluBaker DataXS/DMC2 has similar functionality, but this functionality is not available from within Livelink. It runs on its own. I can send you screen shots of the Logica and BluBaker solutions (we have both running).

Regards, Evert

Van: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Verzonden: maandag 17 augustus 2009 19:46
Aan: eLink Recipient
Onderwerp: LiveReport for document permissions different than parent folder

LiveReport for document permissions different than parent folder

Posted by wilene03admin (Romondo, Jeremy) on 2009/08/17 13:41