Hyland Connect

Audrey_Van_Land · ‎02-17-2022

Is there a report or a query that can be used to report on user groups that have the Dashboard Access Privileges set? I'm not seeing this listed in the User Group / Right Configuration Report created from inside of the Configuration Module.

I need to be able to identify and or report on user groups that have the ability to be able to access the Administration areas for Reporting Dashboards, Categories, Dashboards, Reports.

Larissa_Armand · ‎02-17-2022

Audrey,

That information is in the table DASHBOARDPRIVS.

PRIVILEGE0
BIT	Override Privilege	Value
1	User Access	1
2	Create categories	2
3	Create dashboards	4
4	Create data providers	8
5	Configure External Data Sources	16
6	Create reports	32
7	Author SQL data providers	64
8		128
9		256
10		512
11		1024
12		2048
13	Administrator Access	4096

If you are using an Oracle database, you could query this like:

select trim(G.USERGROUPNAME),
case when bitand(P.PRIVILEGE0, 1) >0 then 'X' end as UserAccess,
case when bitand(P.PRIVILEGE0, 4096) >0 then 'X' end as AdminAccess
from DASHBOARDPRIVS P, USERGROUP G
where P.USERGROUPNUM = G.USERGROUPNUM
and P.USERGROUPNUM = '1602'
;

View answer in original post

Jared_Jozsa2 · ‎02-17-2022

Yoink, I'm stealing this

Barbara_Ebel-La · ‎02-17-2022

@Larissa Armand for the win!

Hyland Connect

User Group & Rights - Reporting Dashboards - Dashboard User Group Privileges