USP_DATALIST_SYSTEMROLECODETABLEPERMISSIONS

Displays code table permissions assigned to the given system role

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_SYSTEMROLECODETABLEPERMISSIONS
(
    @SYSTEMROLEID uniqueidentifier
)
as
    select
        SYSTEMROLEPERM_CODETABLE.ID,
        CODETABLECATEGORY.DESCRIPTION,
        V_INSTALLED_CODETABLECATALOG.UINAME as CODETABLENAME,                        
        case SYSTEMROLEPERM_CODETABLE.ADDPERMISSION when 'Not Set' then '' else SYSTEMROLEPERM_CODETABLE.ADDPERMISSION end as 'ADDPERMISSION',
        case SYSTEMROLEPERM_CODETABLE.UPDATEPERMISSION when 'Not Set' then '' else SYSTEMROLEPERM_CODETABLE.UPDATEPERMISSION end as 'UPDATEPERMISSION',
        case SYSTEMROLEPERM_CODETABLE.DELETEPERMISSION when 'Not Set' then '' else SYSTEMROLEPERM_CODETABLE.DELETEPERMISSION end as 'DELETEPERMISSION'
    from
        dbo.V_INSTALLED_CODETABLECATALOG
    inner join dbo.SYSTEMROLEPERM_CODETABLE
            on V_INSTALLED_CODETABLECATALOG.ID = SYSTEMROLEPERM_CODETABLE.CODETABLECATALOGID
    left outer join dbo.CODETABLECATEGORY
            on V_INSTALLED_CODETABLECATALOG.CATEGORYID = CODETABLECATEGORY.ID
    where
        SYSTEMROLEPERM_CODETABLE.SYSTEMROLEID = @SYSTEMROLEID
    order by
        V_INSTALLED_CODETABLECATALOG.UINAME;