Permissions on Project

[Melyane1]

I want to create a LiveReport showing the Permissions on a Project other than Guest, Member and Coordinator. I want to see who the guests are, who the Membes are and who the Coordinators are.

 

[ggriffit]

something like

https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2403021&objAction=view&show=2

?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[Melyane1]

Good day,

The answer I received to the above question is from 2000 and does not seem to work with LL 9.7. Is there something more recent that I could use?

Tks

 

[ggriffit]

Melyane,
Just ran the SQL in the LiveReport I referenced above, which is :

SELECT b.name type, d.name name
FROM dtreeacl a, kuaf b, kuafchildren c, kuaf d
WHERE dataid = 242001
and a.rightid = b.id
and b.id = c.id
and d.id = c.childid

Where 242001 is my project ID and I got back the following :

Group User
---------------------
Coordinators Admin
Members eLink
Members Coordinators
Guests TestUser

Can you explain what you are seeing or having issues with ?

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/