UFN_SECURITY_APPUSER_GRANTED_SMARTQUERY_IN_SYSTEMROLE

CREATE function dbo.UFN_SECURITY_APPUSER_GRANTED_SMARTQUERY_IN_SYSTEMROLE
(
    @APPUSERID uniqueidentifier,
    @SMARTQUERYID uniqueidentifier
)
  returns bit 
as 
  /*
  Returns true if the user has been granted and not denied the smart query for a System Role.
  */
begin
    --If at least one grant and no deny then return true

    --otherwise, false

    declare @GRANT bit;
    set @GRANT=0;

  --order by GRANTORDENY, deny will be first.


    select top 1 @GRANT=GRANTORDENY
    from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_SMARTQUERY (nolock)
    where APPUSERID = @APPUSERID
    and SMARTQUERYCATALOGID=@SMARTQUERYID
    order by GRANTORDENY ASC; 

    return @GRANT;
end