UFN_DESIGNATION_USERHASSITEACCESS

Returns 1 is the given user has access to the given designation's site.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@DESIGNATIONID uniqueidentifier IN
@CURRENTAPPUSERID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_DESIGNATION_USERHASSITEACCESS
            (
                @DESIGNATIONID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier
            )
            returns bit
            as
            begin

                declare @SITEID uniqueidentifier
                set @SITEID=dbo.UFN_SITEID_MAPFROM_DESIGNATIONID(@DESIGNATIONID)

                declare @SITEGRANTED bit
                set @SITEGRANTED=dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, @SITEID)

                return @SITEGRANTED


            end