UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESS_IN_SYSTEMROLE

CREATE function dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESS_IN_SYSTEMROLE(@APPUSERID uniqueidentifier,@BUSINESSPROCESSID uniqueidentifier)
  returns bit
as 
  /*
  Returns true if user has been granted and not denied the business process 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_BUSINESSPROCESS (nolock)
    where APPUSERID = @APPUSERID
    and BUSINESSPROCESSCATALOGID=@BUSINESSPROCESSID
    order by GRANTORDENY ASC;

    return @GRANT;
end