USP_DATALIST_CLIENTUSERS_SECURITYEXCEPTIONOBJECT

This returns the GUIDS for the user and all of its user groups.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_CLIENTUSERS_SECURITYEXCEPTIONOBJECT(@CLIENTUSERSID int)
as
    set nocount on;

    declare @USERGUIDS table([GUID] uniqueidentifier)

    select [GUID] as OBJECTGUID
    from [dbo].[UFN_CLIENTUSERS_SECURITYEXCEPTIONOBJECTS](@CLIENTUSERSID)