UFN_SYSTEMROLEAPPUSER_GETSITES

Returns a table of sites assigned to a system role application user.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEAPPUSERID	uniqueidentifier	IN

Definition

Copy



            CREATE FUNCTION dbo.UFN_SYSTEMROLEAPPUSER_GETSITES(@SYSTEMROLEAPPUSERID uniqueidentifier)
            returns table
            as
            return 
            (
                select 
                    SYSTEMROLEAPPUSERSITE.ID,
                    SYSTEMROLEAPPUSERSITE.SITEID
                from 
                    dbo.SYSTEMROLEAPPUSERSITE
                where 
                    SYSTEMROLEAPPUSERSITE.SYSTEMROLEAPPUSERID = @SYSTEMROLEAPPUSERID
            )