UFN_SYSTEMROLEAPPUSER_GETACCOUNTINGELEMENTSECURITYGROUPS

Returns a table of accounting element 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_GETACCOUNTINGELEMENTSECURITYGROUPS
      (
                @SYSTEMROLEAPPUSERID uniqueidentifier      
      )
      returns table
      as
      return
      (
                select 
                    SYSTEMROLEAPPUSERACCOUNTINGELEMENTSECURITY.ID,
                    SYSTEMROLEAPPUSERACCOUNTINGELEMENTSECURITY.ACCOUNTINGELEMENTSECURITYGROUPID
                from 
                    dbo.SYSTEMROLEAPPUSERACCOUNTINGELEMENTSECURITY
                where 
                    SYSTEMROLEAPPUSERACCOUNTINGELEMENTSECURITY.SYSTEMROLEAPPUSERID = @SYSTEMROLEAPPUSERID      
      )