UFN_ADHOCQUERY_USERGRANTEDRUN

CREATE function dbo.UFN_ADHOCQUERY_USERGRANTEDRUN
(
    @ADHOCQUERYID uniqueidentifier,
    @APPUSERID uniqueidentifier
)
returns bit
with execute as caller
as 
/*Returns true if the user has been granted and not denied access to run the ad-hoc query for a System Role.*/
begin
    declare @QUERYDEFINITIONXML xml = (select QUERYDEFINITIONXML from dbo.ADHOCQUERY where ID=@ADHOCQUERYID)

    return (case when dbo.UFN_ADHOCQUERY_USERHASRIGHTSTOQUERYVIEWS(@APPUSERID, @QUERYDEFINITIONXML) = 1
                    and dbo.UFN_SECURITY_APPUSER_GRANTED_ADHOCQUERYINSTANCE_IN_SYSTEMROLE(@APPUSERID, @ADHOCQUERYID) = 1
                then 1
            else 0
            end)
end