LiveReport user permissions

I am trying to write a SQL query which shows all active users in Livelink with their permissions (edit, see, delete, reserve). Can anyone help me?We have Livelink 9.6 and use oracle 10gl (TOAD for Oracle)

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

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

Permissions in Livelink are object based, so your report would be for specific documents or folders.

For object permissions (who has what permissions), please see the discussion thread that begins here:

https://knowledge.opentext.com/go/3843113

- Bhupinder

----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, July 15, 2008 9:13 AM
To: eLink Recipient
Subject: LiveReport user permissions

LiveReport user permissions

Posted by jeanine.sieliakus@philips.com (Sieliakus-Burgers, Jeanine) on 07/15/2008 09:12 AM

I am trying to write a SQL query which shows all active users in Livelink with their permissions (edit, see, delete, reserve). Can anyone help me?
We have Livelink 9.6 and use oracle 10gl (TOAD for Oracle)

Appu_Nair

An active user isselect id,name from kuaf where deleted=0 and type=0Here's an excellent article by Alex kowalenko on bitwise operations on the permissions column that may lead you in the right directionhttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=2631180&objAction=viewObjects permissions are stored in dtreeacl and the live reports class shows you in detail the schema iimplicationsAlso only objects have permission while people have only privileges such as login,PA,SA,UA etc etc.Windows ,unix and most other OS/file systems follow the same principle.

Jim_Coursey

Message from Coursey, Jim <jim.coursey@ngc.com> via eLink

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

and information for the objects they have each of those permissions on?

LiveReport user permissions

Posted by jeanine.sieliakus@philips.com (Sieliakus-Burgers, Jeanine) on 07/15/2008 09:12 AM

I am trying to write a SQL query which shows all active users in Livelink with their permissions (edit, see, delete, reserve). Can anyone help me?
We have Livelink 9.6 and use oracle 10gl (TOAD for Oracle)

Tim_Hunter

Trying to determine what you actually want.. you want a report of all users with permissions to every object they are directly assigned permissions on?I have a query that can give you permissions by a particular user.SELECT DTree.dataid ,KUAF.Name UserName ,DTree.Name Object ,nvl(st.subtype, 'UNK: '||DTree.subtype) as ObjType ,DTreeACL.Permissions ,DECODE (DTREEACL.PERMISSIONS , '128' ,'No Rights' ,'130','S' ,'36995','S/SC' ,'62666','S/M' ,'102531','S/SC/M' ,'65670','S/M/AI' ,'102547','S/SC/M/EP' ,'233603','S/SC/M/EA' ,'102535','S/SC/M/AI' ,'118915','S/SC/M/DV' ,'233619','S/SC/M/EP/EA' ,'102551','S/SC/M/EP/AI' ,'118931','S/SC/M/EP/DV' ,'233607','S/SC/M/EA/AI' ,'249987','S/SC/M/EA/DV' ,'118919','S/SC/M/AI/DV' ,'233623','S/SC/M/EP/EA/AI' ,'250003','S/SC/M/EP/EA/DV' ,'118935','S/SC/M/EP/AI/DV' ,'249991','S/SC/M/EA/AI/DV' ,'250007','S/SC/M/EP/EA/AI/DV' ,'118923','S/SC/M/DV/D' ,'127107','S/SC/M/DV/R' ,'127115','S/SC/M/DV/D/R' ,'118939','S/SC/M/EP/DV/D' ,'127123','S/SC/M/EP/DV/R' ,'127131','S/SC/M/EP/DV/D/R' ,'249995','S/SC/M/EA/DV/D' ,'258179','S/SC/M/EA/DV/R' ,'258187','S/SC/M/EA/DV/D/R' ,'118927','S/SC/M/AI/DV/D' ,'127111','S/SC/M/AI/DV/R' ,'127119','S/SC/M/AI/DV/D/R' ,'250011','S/SC/M/EP/EA/DV/D' ,'258195','S/SC/M/EP/EA/DV/R' ,'258203','S/SC/M/EP/EA/DV/D/R' ,'118943','S/SC/M/EP/AI/DV/D' ,'127127','S/SC/M/EP/AI/DV/R' ,'127135','S/SC/M/EP/AI/DV/D/R' ,'249999','S/SC/M/EA/AI/DV/D' ,'258183','S/SC/M/EA/AI/ DV/R' ,'258191','S/SC/M/EA/AI/DV/D/R' ,'250015','S/SC/M/EP/EA/AI/DV/D' ,'258199','S/SC/M/EP/EA/AI/DV/R' ,'258207','Full Perm' ,'16777215','Full Perm' ,'Unk:'||DTREEACL.PERMISSIONS) as Rights FROM DTreeACL,KUAF,DTree,ll_subtypes stWHERE DTreeACL.DataID = DTree.DataID AND DTreeACL.RightID = KUAF.ID AND dtree.subtype = st.id(+) AND DTreeACL.RightID = %1combine that with the previous and you have what you are asking, but be aware this could be a very large resultset.

Martin_Gäckler

Here is how we query for the permissions:select d.*, dt.userId, dt.groupId, k.type, k.name, decode( mod(trunc(permissions/2), 2), 1, ' See', '' ) || decode( mod(permissions, 2), 1, ' See Contents', '' ) || decode( mod(trunc(permissions/65536), 2), 1, ' Modify', '' ) || decode( mod(trunc(permissions/16), 2), 1, ' Permissions', '' ) || decode( mod(trunc(permissions/16384), 2), 1, ' Delete Versions', '' ) || decode( mod(trunc(permissions/8), 2), 1, ' Delete', '' ) || decode( mod(trunc(permissions/8192), 2), 1, ' Reserve', '' )as "Actions"from dtreeacl d, kuaf k, dtree dt where (d.dataid=%1 or d.dataId=-%1)and d.dataid = dt.dataidand d.rightid = k.id(+)Hope this helpsMartin