UFN_SITEALLOWEDFORUSERONFEATURE

Returns true if the given user can access the given site in a role that also grants the given feature.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN
@FEATUREID	uniqueidentifier	IN
@FEATURETYPE	tinyint	IN

Definition

Copy



            create function dbo.UFN_SITEALLOWEDFORUSERONFEATURE 
            (
                @CURRENTAPPUSERID uniqueidentifier,
                @SITEID uniqueidentifier,
                @FEATUREID uniqueidentifier,
                @FEATURETYPE tinyint
            )
            returns bit
            as
            begin 
                if dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1 
                begin
                    return 1;                
                end

                if @SITEID is null
                begin
                    if exists( select 1 from dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@FEATUREID,@FEATURETYPE) where SITEID is null)
                        return 1;
                end
                else
                begin
                    if @SITEID in(select * From dbo.UFN_SITESFORUSERONFEATURE(@CURRENTAPPUSERID,@FEATUREID,@FEATURETYPE))
                        return 1;
                end;        

                return 0;

            end