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 to show permission of a folder and its sub-items

Norman_Leung_(ImvecAdmin_(Delete)_2148619)

I just created a new LiveReport to show all the permissions of a folder (or a container) and its sub-items. I think that it may be useful for some of you guys, therefore I post it here. (I would like to post it to "LiveReport Submission" but I have no rights to add item in that folder) Please feel free to send me comments. By the way, it works only in Oracle. I will be more than happy if someone could modify it and make it work in different databases too.Best Regards,Desmond YeungProject Manager, Imvec (HK) Ltd.desmond@imvec.com.hk

Find more posts tagged with

Comments

eLink User

Message from David Slimmon via eLinkThanks Desmond, I'll have a look!Regards,Dave Slimmondslimmon@opentext.com-----Original Message-----I just created a new LiveReport to show all the permissions of a folder (or acontainer) and its sub-items. I think that it may be useful for some of you guys,therefore I post it here. (I would like to post it to "LiveReport Submission" but Ihave no rights to add item in that folder) Please feel free to send me comments. Bythe way, it works only in Oracle. I will be more than happy if someone could modifyit and make it work in different databases too.Best Regards,Desmond Yeung

eLink User

Message from David Slimmon via eLinkGreat work DesmondI *really* like your LiveReport. That is seriously very cool. Quick note to anybodyreading along though. It appears to be an Oracle only report. Desmond, did youdevelop this one against Oracle? I'm not having much luck with it with MSSQL.Cheers,Dave-----Original Message-----I just created a new LiveReport to show all the permissions of a folder (or acontainer) and its sub-items. I think that it may be useful for some of you guys,therefore I post it here. (I would like to post it to "LiveReport Submission" but Ihave no rights to add item in that folder) Please feel free to send me comments. Bythe way, it works only in Oracle. I will be more than happy if someone could modifyit and make it work in different databases too.Best Regards,Desmond Yeung

Norman_Leung_(ImvecAdmin_(Delete)_2148619)

Well, yes. Since my client is using Oracle as their backend database, I did not consider much on MSSQL. Do you think it is impossible to create a similar SQL in MSSQL? (By the way, I am not familiar with MSSQL)Best regards,Desmond Yeung

Craig Trim

Just another quick note for anyone receiving a CGI Timeout when using this report. Further information on setting this value can be found specifically within the IIS online help.Regards,Craig--Craig TrimProduct SpecialistOpen Text Customer Support Telephone: 0800 9 808 808 (within UK)Telephone: +44 (0) 1494 679 749 (outside UK)Fax: +44 (0) 1494 679 708E-mail: uk-support@opentext.comLiveLinkUP 2002Open Text User ConferenceParis, FranceApril 14-17, 2002Find out how we're helping five million great mindswork together to improve efficiencies and save money.www.opentext.com/livelinkup/

Mary_Slane_Corona

Does this LiveReport still work with 9.7.1 and if so, would you mind listing the code here instead of in the .rpt format?Thank you.

Martin_Gäckler

Hi,I did not check the report but here are ours:1. Permissions in a Folderselect %2, dtree.mimetype, datatype, exatt1,k.name as UserOrGroup,nvl( rtrim( decode( mod( trunc(d.permissions/32768), 2), 0, '', 1, 'See Content / ' ) || decode( mod( trunc(d.permissions/65536), 2), 0, '', 1, 'Modify / ' ) || decode( mod( trunc(d.permissions/16), 2), 0, '', 1, 'Edit Permissions / ' ) || decode( mod( trunc(d.permissions/8), 2), 0, '', 1, 'Delete / ' ) || decode( mod( trunc(d.permissions/4), 2), 0, '', 1, 'Add Children ' ), '/ ' ), 'none' ) as Permsfrom webnodes dtree, dtreeacl d, kuaf kwhere dtree.parentid = %1and dtree.dataid = d.dataidand d.rightid = k.idorder by dtree.name, upper( k.name )2. Permissions in a Folder Treeselect distinct %2, dtree.datatype, dtree.exatt1, level,k.name as UserOrGroup,nvl( rtrim( decode( mod( trunc(d.permissions/32768), 2), 0, '', 1, 'See Content / ' ) || decode( mod( trunc(d.permissions/65536), 2), 0, '', 1, 'Modify / ' ) || decode( mod( trunc(d.permissions/16), 2), 0, '', 1, 'Edit Permissions / ' ) || decode( mod( trunc(d.permissions/8), 2), 0, '', 1, 'Delete / ' ) || decode( mod( trunc(d.permissions/4), 2), 0, '', 1, 'Add Children ' ), '/ ' ), 'none' ) as Permsfrom webnodes dtree, dtreeacl d, kuaf kwhere dtree.dataid = d.dataidand d.rightid = k.idconnect by prior dtree.dataid = dtree.parentidstart with dtree.dataId = %13.Permissions in a Volume Treeselect distinct %2, dtree.datatype, dtree.exatt1, level,k.name as UserOrGroup,nvl( rtrim( decode( mod( trunc(d.permissions/32768), 2), 0, '', 1, 'See Content / ' ) || decode( mod( trunc(d.permissions/65536), 2), 0, '', 1, 'Modify / ' ) || decode( mod( trunc(d.permissions/16), 2), 0, '', 1, 'Edit Permissions / ' ) || decode( mod( trunc(d.permissions/8), 2), 0, '', 1, 'Delete / ' ) || decode( mod( trunc(d.permissions/4), 2), 0, '', 1, 'Add Children ' ), '/ ' ), 'none' ) as Permsfrom webnodes dtree, dtreeacl d, kuaf kwhere dtree.dataid = d.dataidand d.rightid = k.idconnect by prior dtree.dataid = dtree.parentid or -(prior dtree.dataid) = dtree.parentIdstart with dtree.dataId = %1The first report check only direct children of a folder. The second report also checks all subfolders without items that have their own volume (projects, news etc.)The third repots also traveses projects.The reports are used with Oracle 10.x As far as I know, Microsoft does not know a connect by clause.Hope this HelpsMartin

Mary_Slane_Corona

We have Oracle 10, so this is great. I will check the LiveReports as soon as I can and let you know what I find out. Thanks again.

Mary_Slane_Corona

MartinI ran the 1st report--works great. I ran the 2nd report and it is taking forever to run--I think I even brought down Livelink trying to run it. Is there any way to revise the report to make it run quicker?

Martin_Gäckler

The second report should run in an acceptable time. Checking volumes is very expensive, therefore the third one will take a long time 8-(.I check, whether a join to DTreeAncestors will improve performance.Martin

Martin_Gäckler

Hello,here is another version which uses DTreeAncestors:select distinct %2, dtree.datatype, dtree.exatt1,k.name as UserOrGroup,nvl( rtrim( decode( mod( trunc(d.permissions/32768), 2), 0, '', 1, 'See Content / ' ) || decode( mod( trunc(d.permissions/65536), 2), 0, '', 1, 'Modify / ' ) || decode( mod( trunc(d.permissions/16), 2), 0, '', 1, 'Edit Permissions / ' ) || decode( mod( trunc(d.permissions/8), 2), 0, '', 1, 'Delete / ' ) || decode( mod( trunc(d.permissions/4), 2), 0, '', 1, 'Add Children ' ), '/ ' ), 'none' ) as Permsfrom webnodes dtree, dtreeacl d, kuaf kwhere dtree.dataid = d.dataidand d.rightid = k.idand dtree.dataid in (select dataid from dtreeAncestors where AncestorID=%1)DTreeAncestors is part of the recomendations module. Since Munich Re does not use recomendations, I do not have a lot of experience with this module. Our customized livelink did not update this table immediately after a move. Maybe it works better with your livelink. The great advantage is, that it also works for other databases not only oracle.Hope this helpsMartin

Mary_Slane_Corona

It works. Thank you for the revised report.Have a great week.Mary

Aarti_Passi

Hi, Can you tell me the "Type" of the second prompt used in the query. For the understanding of the question I have attached the screen shot of the live report.ThanksAarti

Lindsay_Davies

Message from Lindsay Davies <ldavies@opentext.com> via eLink

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

Hi Aarti,

If you were to import the Livereport from the original sample in the posting (from the Admin.Index pages) then you will see that %2 represents "Filter Permissions".

It is not a User Input parameter so needs no type definition.

I assume the other SQL statements in this thread are similar.

Using "filter permissions" is how you can make a Livereport suitable for general (public) use within a Content Server system, rather than only by an Administrator.

It is how you make sure that any DTree rows returned to the user who runs the report are ones that he/she is allowed to see.

Regards

Lindsay Davies

Open Text UK

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2011 May 05, Thu 10:13
To: eLink Recipient
Subject: RE- Does this still work with 9.7.1

RE- Does this still work with 9.7.1		Posted by apassi@celgene.com (Passi, Aarti ) on 2011/05/05 05:11
In reply to: RE- Does this still work with 9.7.1?		Posted by mgaeckler@munichre.com (G�ler, Martin R) on 2010/07/28 08:58

Hi,
Can you tell me the "Type" of the second prompt used in the query. For the understanding of the question I have attached the screen shot of the live report.

Thanks
Aarti

Rhulani Makhubele

Desmond, this is an excellent report. Well done and thanks for sharing this report.

Colin_Schmidt

While relying on those digital values, it might be safer to check the bits.

Colin J. Schmidt

Knowledgelink Support

CapitalOne | Collaboration Technology

Knowledgelink@capitalone.com

Internal: 433-8910

External: 804-284-8910

Cell: 918-904-9223

Don’t waste space with attachments – follow thesestepsto e-mail links to documents stored in Knowledgelink

From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, March 13, 2017 4:07 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: LiveReport to show permission of a folder and its sub-items

LiveReport to show permission of a folder and its sub-items

Posted by Makhubele, Rhulani On 03/13/2017 04:04 AM

Desmond, this is an excellent report. Well done and thanks for sharing this report.

[To post a comment, use the normal reply function]
Topic:	LiveReport to show permission of a folder and its sub-items
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center CS16

The information contained in this e-mail is confidential and/or proprietary to Capital One and/or its affiliates and may only be used solely in performance of work or services for Capital One. The information transmitted herewith is intended only for use by the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.

ACL-LiveReport-1.rpt

Baber_Amin1

Hi,

Is it for MS SQL Server?

I imported this report into my test system but it's not working.

Any idea?

Thanks,

Baber.