USP_SECURITY_GETGRANTORDENYFORQUERYVIEW

        create procedure dbo.USP_SECURITY_GETGRANTORDENYFORQUERYVIEW(@QUERYVIEWCATALOGID uniqueidentifier, @SYSTEMROLEID uniqueidentifier)
        with execute as caller
        as            
            select 
                ID,
                coalesce(GRANTORDENY, 2) as [GRANTORDENY]
            from dbo.SYSTEMROLEPERM_QUERYVIEW
            where QUERYVIEWCATALOGID = @QUERYVIEWCATALOGID and SYSTEMROLEID = @SYSTEMROLEID;