UFN_SYSTEMROLEAPPUSER_GETSECURITYGROUPS

Returns a table of constituent security groups 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_GETSECURITYGROUPS
            (
                @SYSTEMROLEAPPUSERID uniqueidentifier
            )
            returns table
            as
            return 
            (
                select 
                    SYSTEMROLEAPPUSERCONSTITUENTSECURITY.ID,
                    SYSTEMROLEAPPUSERCONSTITUENTSECURITY.CONSTITUENTSECURITYATTRIBUTEID
                from 
                    dbo.SYSTEMROLEAPPUSERCONSTITUENTSECURITY
                where 
                    SYSTEMROLEAPPUSERCONSTITUENTSECURITY.SYSTEMROLEAPPUSERID = @SYSTEMROLEAPPUSERID
            )