UFN_SECURITY_WEBDASHBOARDPRIVILEGE_GETASSIGNMENTSLIST

Returns a list of system roles and their web dashboard privilege assignments.

Return

Return Type
table

Definition

Copy



create function dbo.UFN_SECURITY_WEBDASHBOARDPRIVILEGE_GETASSIGNMENTSLIST()
returns table
as
return
(
select SYSTEMROLE.ID,
    SYSTEMROLE.NAME,
    (select GRANTORDENY from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = SYSTEMROLE.ID and SYSTEMPRIVILEGECATALOGID = '0A17B2A7-AB84-4F69-8107-8C4696C86A20') ISGRANTEDPERSONALIZEPAGES,
    (select GRANTORDENY from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = SYSTEMROLE.ID and SYSTEMPRIVILEGECATALOGID = '4BBB38E1-C083-40D5-95D5-B6615E415B2F') ISGRANTEDADDPAGES,
    (select GRANTORDENY from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = SYSTEMROLE.ID and SYSTEMPRIVILEGECATALOGID = '0ec592a0-416c-4052-b80f-99fc324dd918') ISGRANTEDASSIGNPAGEPERMISSIONS,
    (select GRANTORDENY from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = SYSTEMROLE.ID and SYSTEMPRIVILEGECATALOGID = '59A5486F-E153-4714-A2C7-FD2E521596F3') ISGRANTEDADDFOLDERS,
    (select GRANTORDENY from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = SYSTEMROLE.ID and SYSTEMPRIVILEGECATALOGID = '6A5E05FD-72F3-4AE8-B683-4DA1D72A4A3C') ISGRANTEDEDITFOLDERS,
    (select GRANTORDENY from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE where SYSTEMROLEID = SYSTEMROLE.ID and SYSTEMPRIVILEGECATALOGID = '338CCF93-7B86-4BCD-B08A-8D7F0E625769') ISGRANTEDDELETEFOLDERS
from dbo.SYSTEMROLE
);