Object Privileges

Joanne_Bain_(ecorecuser1_-_(deleted))

We would like to run a report on object creation privileges, i.e. who can create which objects. Does anyone have any suggestions?

Lindsay_Davies

Message from Lindsay Davies via eLinkHi Joanne,Assuming that you mean restrictions applied through the Administer Object and Usage Privileges page (?func=admin.adminfactories) in Livelink, then the following SQL can be used as a start point.select k.name,k.type,k.id,kc.childid,k2.name from kuaf k,kuaf k2,kuafchildren kc where k.type=4 and k.id=kc.id and kc.childid=k2.id orderby k.nameThe output shows the restricted item (psuedo group) and those users orgroups who have access (are members).E.g.NAME TYPE ID CHILDID NAME------------------------------ ---------- ---------- ------------------------------Category (131) 4 2005 1000 AdminCategory Folder (132) 4 2006 1000 AdminForm (223) 4 51824 50852 mannyHTML View (226) 4 51503 50852 mannyLiveReport (299) 4 2008 1000 AdminLiveReport (299) 4 2008 136303opentext\ldaviesProject Template (543) 4 55638 1000 AdminProject Template (543) 4 55638 14213 jbloggsProject Template (543) 4 55638 35813 asumProject Template (543) 4 55638 50852 mannyWorkflow Status (190) 4 51494 51079 mannyx11 rows selected.RegardsLindsay -----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com] Sent: 07 February 2005 04:02To: eLink RecipientSubject: Object PrivilegesObject PrivilegesPosted by Bain, Joanne on 02/06/2005 10:57 PMWe would like to run a report on object creation privileges, i.e. whocan create which objects. Does anyone have any suggestions?[To reply to this thread, use your normal E-mail reply function.]============================================================Discussion: Livelink LiveReports Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=2249677&objAction=viewLivelink Server:https://knowledge.opentext.com/knowledge/livelink.exe