UFN_CLIENTUSERS_SECURITYEXCEPTIONOBJECTS

Returns the GUIDS for all exception objects associated with the given user.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTUSERSID	int	IN

Definition

Copy



CREATE function [dbo].[UFN_CLIENTUSERS_SECURITYEXCEPTIONOBJECTS]
(    
    @CLIENTUSERSID int
)
returns table
as
return
(
    select [GUID]
    from [dbo].[CLIENTUSERS]
    where [ID] = @CLIENTUSERSID

    union all

    select CR.[GUID]
    from dbo.FNUSERROLES(@CLIENTUSERSID, 1) UR
    inner join [dbo].[CLIENTROLES] CR
    on CR.ID = UR.CLIENTROLESID
)