UFN_APPUSER_CHECK_PROXYUSER_BYUSERNAME

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@CUSTOMAUTHENTICATIONUSERID	nvarchar(255)	IN

Definition

Copy



            CREATE function dbo.UFN_APPUSER_CHECK_PROXYUSER_BYUSERNAME (@CUSTOMAUTHENTICATIONUSERID nvarchar(255))
                returns bit
                as begin
                    declare @ISPROXYUSER bit = 0;
                    declare @CUSTOMAUTHENTICATIONUSERIDCOUNT int;

                    select @CUSTOMAUTHENTICATIONUSERIDCOUNT = count(1) from dbo.APPUSER where CUSTOM_AUTHENTICATION_USERID = @CUSTOMAUTHENTICATIONUSERID;

                    if @CUSTOMAUTHENTICATIONUSERIDCOUNT = 1
                        begin
                            select @ISPROXYUSER = isnull(ISPROXYUSER, 0)
                            from dbo.APPUSER
                            where CUSTOM_AUTHENTICATION_USERID = @CUSTOMAUTHENTICATIONUSERID;
                        end

                    return @ISPROXYUSER;
                end