UFN_SYSTEMROLEADGROUP_GETSECURITYGROUPS

Returns a table of constituent security groups assigned to a system role active directory group.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMROLEADGROUPID	uniqueidentifier	IN

Definition

Copy



            CREATE FUNCTION dbo.UFN_SYSTEMROLEADGROUP_GETSECURITYGROUPS
            (
                @SYSTEMROLEADGROUPID uniqueidentifier
            )
            returns table
            as
            return 
            (
                select 
                    SYSTEMROLEADGROUPCONSTITUENTSECURITY.ID,
                    SYSTEMROLEADGROUPCONSTITUENTSECURITY.CONSTITUENTSECURITYATTRIBUTEID
                from 
                    dbo.SYSTEMROLEADGROUPCONSTITUENTSECURITY
                where 
                    SYSTEMROLEADGROUPCONSTITUENTSECURITY.SYSTEMROLEADGROUPID = @SYSTEMROLEADGROUPID
            )