nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Livereport - list permission from a system object in admin section

Julien_Discours

i have a problem for list permission from a system object, probably need to uninstall a patch.

I cannot do this operation right, so now i need to list permission from a system object by a livereport.

Is it possible ? if yes, i need specific one for system object 299.

Does someone already created one ?

Regards,

Julien Discours.

Find more posts tagged with

Comments

Colin_Schmidt

299 is a LiveReport. If you want to list permissions, it's no different than any other object.

select dta.dataid, dt1.name "File name", dt2.name "Parent", k1.name "Owner", case when dta.rightid > 0 then k2.name when dta.rightid = -1 then 'Public Access' when dta.rightid = -2 and dta.acltype=4 then 'SysAdmins' when dta.rightid = -3 then '<None>' else 'Other ['||to_char(dta.rightid)||']' end RightID, case when dta.acltype = 0 then 'ACL Addt2.' when dta.acltype = 1 then 'Owner' when dta.acltype = 2 then 'Owner Grp' when dta.acltype = 3 then 'PubAcc' when dta.acltype = 4 then 'SysAdm' else 'Other' end ACLtype, case when dta.see = 1 then 'See' when dta.see = 2 then 'See Contents' when dta.see = 3 then 'Modify' when dta.see = 4 then 'Delete' else 'None' end See, substr(decode(bitand(dta.permissions,2),0,'None, ') || decode(bitand(dta.permissions,2),2,'See | ') || decode(bitand(dta.permissions,36865),36865,'See Contents | ') || decode(bitand(dta.permissions,65536),65536,'Modify | ') || decode(bitand(dta.permissions,16),16,'Edit Permissions | ') || decode(bitand(dta.permissions,131072),131072,'Edit Attributes | ') || decode(bitand(dta.permissions,4),4,'Add Items | ') || decode(bitand(dta.permissions,16384),16384,'Delete Versions | ') || decode(bitand(dta.permissions,8),8,'Delete | ') || decode(bitand(dta.permissions,8192),8192,'Reserve, ') , 1, length(decode(bitand(dta.permissions,2),0,'None, ') || decode(bitand(dta.permissions,2),2,'See | ') || decode(bitand(dta.permissions,36865),36865,'See Contents | ') || decode(bitand(dta.permissions,65536),65536,'Modify | ') || decode(bitand(dta.permissions,16),16,'Edit Permissions | ') || decode(bitand(dta.permissions,131072),131072,'Edit Attributes | ') || decode(bitand(dta.permissions,4),4,'Add Items | ') || decode(bitand(dta.permissions,16384),16384,'Delete Versions | ') || decode(bitand(dta.permissions,8),8,'Delete | ') || decode(bitand(dta.permissions,8192),8192,'Reserve, ')) -2) "DtreePermissions" from dtreeacl dta join dtree dt1 on dta.dataid = dt1.dataid join kuaf k1 on dt1.createdby = k1.id left outer join kuaf k2 on dta.rightid = k2.id join dtree dt2 on dta.parentid = dt2.dataid where dta.dataid = %1 order by dta.acltype desc

Julien_Discours

This report can be help thanks Colin.

In fact, this not really permission right do I need. But most a report reading users and groups permission from a system object.

Cordialement,

_____________________________________

Julien Discours

DCS POP - GPA Technologie Innovation -

Pôle Construction

Socle Livelink

AXA France Services

De : eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Envoyé : mercredi 14 mars 2012 13:43
À : eLink Recipient
Objet : Livereport - list permission from a system object in admin section

Livereport - list permission from a system object in admin section

Posted bycolin.schmidt@almacgroup.com (Schmidt, Colin J) On 03-14-2012 08:40

299 is a LiveReport. If you want to list permissions, it's no different than any other object.

[To post a comment, use the normal reply function]
Topic:	Livereport - list permission from a system object in admin section
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

----------------------------------------------------------------------
Ce message est confidentiel. Son contenu ne represente en aucun cas un
engagement de la part de AXA France sous reserve de tout accord conclu
par ecrit entre vous et AXA France. Toute publication, utilisation
ou diffusion, meme partielle, doit etre autorisee prealablement. Si
vous n'etes pas destinataire de ce message, merci d'en avertir
immediatement l'expediteur.

This message is confidential. Its contents do not constitute a
commitment by AXA France except where provided for in a written
agreement between you and AXA France. Any unauthorised disclosure, use
or dissemination, either whole or partial, is prohibited. If you are
not the intended recipient of the message, please notify the sender
immediately.
----------------------------------------------------------------------

Colin_Schmidt

My apologies here. I'm not quite understanding your request or question. You want "users and groups permission from a system object". This translates the permissions for each User or Group. I have one that will translate it for the object selected and one that will do it for all objects within the selected Container....in ORACLE.

Julien_Discours

Thanks for your reply back Colin.

Yes, i want user and groups permission report from a system object. Normaly, we can list those informations by the admin.adminfactories in the admin section.

But my content server cannot browse user and group. A report can solve my problem !

Regards,

_____________________________________

Julien Discours

DCS POP - GPA Technologie Innovation -

Pôle Construction

Socle Livelink

AXA France Services

De : eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Envoyé : jeudi 15 mars 2012 12:31
À : eLink Recipient
Objet : RE Livereport - list permission from a system object in admin section

RE Livereport - list permission from a system object in admin section

Posted bycolin.schmidt@almacgroup.com (Schmidt, Colin J) On 03-15-2012 07:26

[To post a comment, use the normal reply function]
Topic:	Livereport - list permission from a system object in admin section
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

Appu_Nair

So basically what you are asking is on the page that shows admin.adminfactories

if you see LiveReport (299) 'Restricted ' and you click that you will see Admin,and any number of groups/users who has Object&Usage Privileges to that . In your livelink they have a module that does not allow you access to see that info maybe 'Privacy Panel'

You want to query the db thru a LR that shows you that info is that what you are asking?

Appu_Nair

Anyways I also wanted to figure that out and my research is shared

I think it is correct from what I can see in my system

https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=23408678&objAction=download&viewType=1

I hope you know that given a kuaf.id its relation to kuafchildren.Type=4 is what I think the admin.factories are coded to show

Colin_Schmidt

Ahhh...now I understand. Done.

Colin_Schmidt

Part of this is seen in the Factories page by hovering the mouse over the name. It lists the GroupID and the ContextID. Thank you, it gives me an idea to report the contents of this page.

Colin_Schmidt

Here are my simplified versions.

r-List all Object Usage and Privileges.llreport

r-List all Groups_Users with Privileges on Objects [UserID].llreport

Julien_Discours

Thanks for your help.

Finaly, I have created the report, if someone are interested :

select a.Name, a.type, a.deleted from kuaf a, kuafchildren b where a.ID=b.childID and b.ID=7113312

a.type & a.deleted is not important.

Regards,

_____________________________________

Julien Discours

DCS POP - GPA Technologie Innovation -

Pôle Construction

Socle Livelink

AXA France Services

_____________________________________

De : eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Envoyé : vendredi 16 mars 2012 15:56
À : eLink Recipient
Objet : RE RE Livereport - list permission from a system object in admin section

RE RE Livereport - list permission from a system object in admin section

Posted bycolin.schmidt@almacgroup.com (Schmidt, Colin J) On 03-16-2012 10:44

Here are my simplified versions.

Attachment Links:

r-List all Object Usage and Privileges.llreport (1 KB)

r-List all Groups_Users with Privileges on Objects [UserID].llreport (1 KB)

[To post a comment, use the normal reply function]
Topic:	Livereport - list permission from a system object in admin section
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center