How to determine 'groups' & 'project group' membership ?

Cedric_Goudaillier_(gtsadmin_-_(deleted))

Hello,I want to create a 'Filter Permission' query to be ran outside of LL. I definitely need the list of 'groups' & 'Project groups'(ie Coordinator, Member or Guest of a project)IDs to do this. I tried "select ID From KUAFCHILDREN where CHILDID = 'UserID' " but it only gives me the Groups & 'Project Coordinator' groups.Idea anyone ?Thanks,Vincent ReipEbonevincent.reip@ebone.com

Find more posts tagged with

Comments

eLink User

Message from Alex Kowalenko via eLinkYou need to use KUAFRightsList which is a flat table of all the groups auser belongs to. Note that KUAFChildren is a hierarchical table that must betraversed to find all groups of a user. This is what the former table has.Alex KowalenkoSenior Consultant - Open Text Professional Services+1 613 838-5220alexk@opentext.com-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Monday, January 29, 2001 7:09 AMTo: eLink RecipientSubject: How to determine 'groups' & 'project group' membership ?How to determine 'groups' & 'project group' membership ?Posted by GTSAdmin on 01/29/2001 07:05 AMHello,I want to create a 'Filter Permission' query to be ran outside of LL. Idefinitely need the list of 'groups' & 'Project groups'(ie Coordinator,Member or Guest of a project)IDs to do this. I tried "select ID FromKUAFCHILDREN where CHILDID = 'UserID' " but it only gives me the Groups &'Project Coordinator' groups.Idea anyone ?Thanks,Vincent ReipEbonevincent.reip@ebone.com[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

Thomas Heusser

Who populats KUAFRightsList ?

On our system, the Table exists, but is Empty ... ???

Thomas

Bhupinder_Singh

The discussion postings in this thread which mention KUAFRightsList date back to 2001. Here are some more recent notes I have on this table:

The KUAFRightsList table is no longer used as of Livelink 9.1 SP3. Page 2 of the Livelink 9.1 SP3 release notes (located at https://knowledge.opentext.com/knowledge/llisapi.dll/open/2937075 ) indicate that:

"Prior to 9.1.0 SP3, the rights list for an individual user was computed, cached and stored in the database (table KUAFRightsList) on a per-user basis.

Livelink 9.1.0 SP3 no longer uses the KUAFRightsList table. Instead, it generates a user’s rights list from the KUAFChildren table in one of two ways:

ô If the database is not Oracle or if Oracle is unable to perform a CONNECT BY PRIOR on the KUAFChildren table, then Livelink caches the KUAFChildren table in memory and uses it to generate the set of all parents for any given user to get the user’s rights list. This can also be the forced behavior if the wantForceChildCache parameter in the opentext.ini file is set to TRUE.

ô Otherwise, Livelink obtains the rights list using the Oracle CONNECT BY PRIOR clause in a select statement."

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Systems Administrator, Cloud Services
Open Text, Waterloo, Ontario, Canada
----------------------------------------------