USP_DATALIST_APPUSERCODETABLES

Returns a list of code table permissions granted to the given application user.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_APPUSERCODETABLES (@APPUSERID uniqueidentifier)
as
    select
        CT.ID,
        CT.UINAME as CODETABLENAME, 
        CTC.DESCRIPTION,
        dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYADD_IN_SYSTEMROLE(@APPUSERID, CT.ID), 
        dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYUPDATE_IN_SYSTEMROLE(@APPUSERID, CT.ID),
        dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYDELETE_IN_SYSTEMROLE(@APPUSERID, CT.ID)
    from 
        dbo.CODETABLECATALOG as CT inner join dbo.CODETABLECATEGORY as CTC on CT.CATEGORYID = CTC.ID
    where 
        (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYADD_IN_SYSTEMROLE(@APPUSERID, CT.ID) = 1) OR 
        (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYUPDATE_IN_SYSTEMROLE(@APPUSERID, CT.ID) = 1) OR 
        (dbo.UFN_SECURITY_APPUSER_GRANTED_CODETABLEENTRYDELETE_IN_SYSTEMROLE(@APPUSERID, CT.ID) = 1)
    order by 
        CT.UINAME;