UFN_RESEARCHGROUP_USERCANACCESS

CREATE function dbo.UFN_RESEARCHGROUP_USERCANACCESS(
                @RESEARCHGROUPID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier
    )
            returns bit
            as
            begin

        if (dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID) = 1)
            return 1;

        if (dbo.UFN_SECURITY_APPUSER_GRANTED_SYSTEMPRIVILEGE_IN_SYSTEMROLE(@CURRENTAPPUSERID,'5ff6322a-c325-40e3-8a20-320ca9365f5f') = 1) and
              exists ( select top 1 1 from dbo.RESEARCHGROUP where ID = @RESEARCHGROUPID and ADMINONLY = 0 )
            return 1;


        if exists (
                Select 1 from RESEARCHGROUP
                where ID = @RESEARCHGROUPID and 
                    (OTHERSCANVIEW = 1 OR OWNERID = @CURRENTAPPUSERID) and
                    (ADMINONLY = 0)
            )
            return 1;

        return 0;

            end