USP_SECURITY_APPUSER_GETWEBDASHBOARDPRIVILEGES

Gets the web dashboard privileges assigned to a given user.
Parameters

Parameter	Parameter Type	Mode
@APPUSERID	uniqueidentifier	IN
@ISGRANTEDPERSONALIZEPAGES	bit	INOUT
@ISGRANTEDADDPAGES	bit	INOUT
@ISGRANTEDASSIGNPAGEPERMISSIONS	bit	INOUT
@ISGRANTEDADDFOLDERS	bit	INOUT
@ISGRANTEDEDITFOLDERS	bit	INOUT
@ISGRANTEDDELETEFOLDERS	bit	INOUT
Definition

Copy


create procedure dbo.USP_SECURITY_APPUSER_GETWEBDASHBOARDPRIVILEGES(@APPUSERID uniqueidentifier,
    @ISGRANTEDPERSONALIZEPAGES bit = null output,
    @ISGRANTEDADDPAGES bit = null output,
    @ISGRANTEDASSIGNPAGEPERMISSIONS bit = null output,
    @ISGRANTEDADDFOLDERS bit = null output,
    @ISGRANTEDEDITFOLDERS bit = null output,
    @ISGRANTEDDELETEFOLDERS bit = null output)
as
    set nocount on;

    declare @ISSYSADMIN bit;
    set @ISSYSADMIN = 0;

    select @ISSYSADMIN = ISSYSADMIN from dbo.APPUSER where ID = @APPUSERID;

    if @ISSYSADMIN = 1
    begin
        set @ISGRANTEDPERSONALIZEPAGES = 1;
        set @ISGRANTEDADDPAGES = 1;
        set @ISGRANTEDASSIGNPAGEPERMISSIONS = 1;
        set @ISGRANTEDADDFOLDERS = 1;
        set @ISGRANTEDEDITFOLDERS = 1;
        set @ISGRANTEDDELETEFOLDERS = 1;        
    end
    else
    begin

        if exists(select GRANTORDENY 
            from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE 
                inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_SYSTEMPRIVILEGE.SYSTEMROLEID = SYSTEMROLE.ID
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.SYSTEMROLEID = SYSTEMROLE.ID
            where SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID
                and SYSTEMPRIVILEGECATALOGID = '0A17B2A7-AB84-4F69-8107-8C4696C86A20'
                and GRANTORDENY = 1)
            set @ISGRANTEDPERSONALIZEPAGES = 1;
        else
            set @ISGRANTEDPERSONALIZEPAGES = 0;

        if exists(select GRANTORDENY 
            from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE 
                inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_SYSTEMPRIVILEGE.SYSTEMROLEID = SYSTEMROLE.ID
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.SYSTEMROLEID = SYSTEMROLE.ID
            where SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID
                and SYSTEMPRIVILEGECATALOGID = '4BBB38E1-C083-40D5-95D5-B6615E415B2F'
                and GRANTORDENY = 1)
            set @ISGRANTEDADDPAGES = 1;
        else
            set @ISGRANTEDADDPAGES = 0;

        if exists(select GRANTORDENY 
            from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE 
                inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_SYSTEMPRIVILEGE.SYSTEMROLEID = SYSTEMROLE.ID
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.SYSTEMROLEID = SYSTEMROLE.ID
            where SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID
                and SYSTEMPRIVILEGECATALOGID = '0ec592a0-416c-4052-b80f-99fc324dd918'
                and GRANTORDENY = 1)
            set @ISGRANTEDASSIGNPAGEPERMISSIONS = 1;
        else
            set @ISGRANTEDASSIGNPAGEPERMISSIONS = 0;

        if exists(select GRANTORDENY 
            from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE 
                inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_SYSTEMPRIVILEGE.SYSTEMROLEID = SYSTEMROLE.ID
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.SYSTEMROLEID = SYSTEMROLE.ID
            where SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID
                and SYSTEMPRIVILEGECATALOGID = '59A5486F-E153-4714-A2C7-FD2E521596F3'
                and GRANTORDENY = 1)
            set @ISGRANTEDADDFOLDERS = 1;
        else
            set @ISGRANTEDADDFOLDERS = 0;

        if exists(select GRANTORDENY 
            from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE 
                inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_SYSTEMPRIVILEGE.SYSTEMROLEID = SYSTEMROLE.ID
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.SYSTEMROLEID = SYSTEMROLE.ID
            where SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID
                and SYSTEMPRIVILEGECATALOGID = '6A5E05FD-72F3-4AE8-B683-4DA1D72A4A3C'
                and GRANTORDENY = 1)
            set @ISGRANTEDEDITFOLDERS = 1;
        else
            set @ISGRANTEDEDITFOLDERS = 0;

        if exists(select GRANTORDENY 
            from dbo.SYSTEMROLEPERM_SYSTEMPRIVILEGE 
                inner join dbo.SYSTEMROLE on SYSTEMROLEPERM_SYSTEMPRIVILEGE.SYSTEMROLEID = SYSTEMROLE.ID
                inner join dbo.SYSTEMROLEAPPUSER on SYSTEMROLEAPPUSER.SYSTEMROLEID = SYSTEMROLE.ID
            where SYSTEMROLEAPPUSER.APPUSERID = @APPUSERID
                and SYSTEMPRIVILEGECATALOGID = '338CCF93-7B86-4BCD-B08A-8D7F0E625769'
                and GRANTORDENY = 1)
            set @ISGRANTEDDELETEFOLDERS = 1;
        else
            set @ISGRANTEDDELETEFOLDERS = 0;
    end;