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; } } }

Is there a way to create a Live Report to show what a specific group has permissions to?

wmader

Is there a way to create a Live Report to show what a specific group has permissions to? I have numerous groups and would like to know what permissions are assigned to a group. Is this possible ? Using oracle database.

Find more posts tagged with

Comments

Appu_Nair

I am not sure the phrasing of the qn is the way livelink does its work.In livelink(and in file systems) you have objects(like ,folders documents) You put on its Access control List(ACL's) what Groups of livelink groups or users can see it.A user has some privileges like (Login,PA,SA etc etc).So really what you want to know is if I have a group called "My Big Bad Group' you may want to know if this group is on the ACL of what all objects in livelink and what the permission bits are.Even a livelink module exists that crawls the objects and shows the permissions on them.Here's a linkhttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=4459811&objAction=viewHere's anotherhttps://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=17615694&objAction=view&show=2

CBancroft

Message from Chris Bancroft <cbancrof@opentext.com> via eLink

eLink

Here is something provided AS IS that another customer used – Oracle only

You would pass in the groupid

They are not pretty ….

SELECT

A.DATAID as folderid

,D1.NAME as ObjectName

,D1.DATAID

,nvl(st.subtype, 'UNK: '||d1.subtype) as ObjType

,CASE A.RIGHTID

WHEN -1 THEN 'Public Access'

WHEN -2 THEN 'System Administrators'

ELSE 'Group ID: ' ||A.RIGHTID

END as privsassignedto

,CASE A.Permissions

WHEN 128 THEN 'No Rights'

WHEN 130 THEN 'S'

WHEN 36995 THEN 'S/SC'

WHEN 36999 THEN 'S/SC/AI'

WHEN 62666 THEN 'S/M'

WHEN 65670 THEN 'S/M/AI'

WHEN 102531 THEN 'S/SC/M'

WHEN 102535 THEN 'S/SC/M/AI'

WHEN 102547 THEN 'S/SC/M/EP'

WHEN 102551 THEN 'S/SC/M/EP/AI'

WHEN 118915 THEN 'S/SC/M/DV'

WHEN 118919 THEN 'S/SC/M/AI/DV'

WHEN 118923 THEN 'S/SC/M/DV/D'

WHEN 118927 THEN 'S/SC/M/AI/DV/D'

WHEN 118931 THEN 'S/SC/M/EP/DV'

WHEN 118939 THEN 'S/SC/M/EP/DV/D'

WHEN 118935 THEN 'S/SC/M/EP/AI/DV'

WHEN 118943 THEN 'S/SC/M/DP/AI/DV/D'

WHEN 127107 THEN 'S/SC/M/DV/R'

WHEN 127111 THEN 'S/SC/M/AI/DV/R'

WHEN 127115 THEN 'S/SC/M/DV/D/R'

WHEN 127119 THEN 'S/SC/M/AI/DV/D/R'

WHEN 127123 THEN 'S/SC/M/EP/DV/R'

WHEN 127127 THEN 'S/SC/M/EP/AI/DV/R'

WHEN 127131 THEN 'S/SC/M/EP/DV/D/R'

WHEN 127135 THEN 'S/SC/M/EP/AI/DV/D/R'

WHEN 233603 THEN 'S/SC/M/EA'

WHEN 233607 THEN 'S/SC/M/EA/AI'

WHEN 233619 THEN 'S/SC/M/EP/EA'

WHEN 233623 THEN 'S/SC/M/EP/EA/AI'

WHEN 249987 THEN 'S/SC/M/EA/DV'

WHEN 249991 THEN 'S/SC/M/EA/AI/DV'

WHEN 249995 THEN 'S/SC/M/EA/DV/D'

WHEN 249999 THEN 'S/SC/M/EA/AI/DV/D'

WHEN 250003 THEN 'S/SC/M/EP/EA/DV'

WHEN 250007 THEN 'S/SC/M/EP/EA/AI/DV'

WHEN 250011 THEN 'S/SC/M/EP/EA/DV/D'

WHEN 250015 THEN 'S/SC/M/EP/EA/AI/DV/D'

WHEN 258179 THEN 'S/SC/M/EA/DV/R'

WHEN 258183 THEN 'S/SC/M/EA/AI/DV/R'

WHEN 258187 THEN 'S/SC/M/EA/DV/D/R'

WHEN 258191 THEN 'S/SC/M/EA/AI/DV/D/R'

WHEN 258195 THEN 'S/SC/M/EP/EA/DV/R'

WHEN 258199 THEN 'S/SC/M/EP/EA/AI/DV/R'

WHEN 258203 THEN 'S/SC/M/EP/EA/DV/D/R'

WHEN 258207 THEN 'Full Permissions'

WHEN 16777215 THEN 'Admin'

ELSE 'Unk: ' ||A.Permissions

END as Permissions

,K.NAME as GroupName

FROM DTREE D1

, DTREEACL A

, KUAF K

,ll_subtypes st

WHERE A.DATAID = D1.DATAID

AND A.ACLTYPE = 0

/* AND D1.SUBTYPE = 0 -- FOLDERS ARE 0 */

AND D1.subtype = st.id(+)

AND K.ID = A.RIGHTID

AND A.RIGHTID IN (%1)

ORDER BY K.NAME, D1.NAME

Another option

SELECT
A.DATAID as folderid
,D1.NAME as ObjectName
,D1.DATAID
,nvl(st.subtype, 'UNK: '||d1.subtype) as ObjType
,CASE A.RIGHTID
WHEN -1 THEN 'Public Access'
WHEN -2 THEN 'System Administrators'
ELSE 'Group ID: ' ||A.RIGHTID
END as privsassignedto
,(CASE WHEN mod(floor(A.PERMISSIONS / 2),2) = 1 then 'S' else null end)||
(CASE WHEN mod(floor(A.PERMISSIONS/36865),2) = 1 then '/SC' else null END)||
(CASE WHEN mod(floor(A.PERMISSIONS/65536),2) = 1 then '/M' else null END)||
(CASE WHEN mod(floor(A.PERMISSIONS/16),2) = 1 then '/EP' else null END)||
(CASE WHEN mod(floor(A.PERMISSIONS/131072),2) = 1 then '/EA' else null END)||
(CASE WHEN mod(floor(A.PERMISSIONS/4),2) = 1 then '/AI' else null END)||
(CASE WHEN mod(floor(A.PERMISSIONS/16384),2) = 1 then '/DV' else null END)||
(CASE WHEN mod(floor(A.PERMISSIONS/8),2) = 1 then '/D' else null END)||
(CASE WHEN mod(floor(A.PERMISSIONS/8192),2) = 1 then '/R' else null END)
as PERMISSIONS
,K.NAME as GroupName
FROM DTREE D1
, DTREEACL A
, KUAF K
,ll_subtypes st
WHERE A.DATAID = D1.DATAID
/* AND A.ACLTYPE = 0 */
/* AND D1.SUBTYPE = 0 -- FOLDERS ARE 0 */
AND D1.subtype = st.id(+)
AND K.ID = A.RIGHTID
AND A.RIGHTID IN (%1)
ORDER BY K.NAME, D1.NAME

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, April 06, 2011 11:23 AM
To: eLink Recipient
Subject: Is there a way to create a Live Report to show what a specific group has permissions to?

Is there a way to create a Live Report to show what a specific group has permissions to?

Posted by wmader@jeffco.us (Mader, Walt) on 2011/04/06 11:21

[To reply to this thread, use your normal E-mail reply function.]
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

wmader

How would I use this example in a Live Report? I'm not very experienced with SQL. Could I take the above example and plug it in to the SQL portion when edit the auto Live report or what modifications would I need to make.? Or is there documentation on this ?

CBancroft

Message from Chris Bancroft <cbancrof@opentext.com> via eLink

eLink

Yes, the sql would be placed in the sql box of the LiveReport. It takes user input so you would set up the report accordingly.

Content Server comes with a number of canned reports that you can look at as examples. They can be accessed from the Personal menu -> Reports and then clicking on the LiveReports tab.

You can also use the Add Item button to create a new LiveReport and when the report page opens click on the Help -> For this Page. It will open the help files related to LiveReports that you can then step through.

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Wednesday, April 06, 2011 1:43 PM
To: eLink Recipient
Subject: Re group permissions

Re group permissions		Posted by wmader@jeffco.us (Mader, Walt) on 2011/04/06 13:38
In reply to: RE Is there a way to create a Live Report to show what a specific group has permissions to?		Posted by cbancrof (Bancroft, Chris G) on 2011/04/06 11:34

[To reply to this thread, use your normal E-mail reply function.]
Topic:	Is there a way to create a Live Report to show what a specific group has permissions to?
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.

wmader

what does the ll_sybtype mean in the above example?

wmader

Took the above example ( 1st option) and plugged it into a Auto Live Report with user input , can't make this work. is there some form of syntax I have to follow it gives me an error saying it is looking for a FROM statement

Lindsay_Davies

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

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

I'm guessing here, but the sample has the comma to separate terms in front of the term on the next line.

That is a formatting trick to make it easier to comment out terms

So after the case statement END as Permissions, the K.name as group name needs a comma before it.

Then that term is complete and the From on the next line makes sense.

One of those commas before From is missing, I expect.

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: 2011 April 07, Thu 22:46
To: eLink Recipient
Subject: re re group permissions

re re group permissions		Posted by wmader@jeffco.us (Mader, Walt) on 2011/04/07 17:44
In reply to: RE Is there a way to create a Live Report to show what a specific group has permissions to?		Posted by cbancrof (Bancroft, Chris G) on 2011/04/06 11:34

CBancroft

Message from Chris Bancroft <cbancrof@opentext.com> via eLink

eLink

One can only speculate at what is wrong as nothing was included showing the error response.

A common issue with sql in livereports is that users do a copy/paste action to place the sql in the box. When done this way you risk the format being changed. Usually it is spaces between the ‘words’ or operators. I would suggest either typing the statements in manually so you know they are spaced properly or cursor through the lines using the error message as a guide and find where the format is off.

From: eLink Discussion: Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, April 07, 2011 5:46 PM
To: eLink Recipient
Subject: re re group permissions

re re group permissions		Posted by wmader@jeffco.us (Mader, Walt) on 2011/04/07 17:44
In reply to: RE Is there a way to create a Live Report to show what a specific group has permissions to?		Posted by cbancrof (Bancroft, Chris G) on 2011/04/06 11:34

[To reply to this thread, use your normal E-mail reply function.]
Topic:	Is there a way to create a Live Report to show what a specific group has permissions to?
Discussion:	Live Reports Discussion
Livelink Server:	knowledge-wlweb01

To Unsubscribe from this Discussion, send an e-mail to unsubscribe.livereportsdiscussion@elinkkc.opentext.com.