UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE

CREATE function dbo.UFN_SECURITY_APPUSER_GRANTED_FORM_IN_SYSTEMROLE(@APPUSERID uniqueidentifier,@FORMID uniqueidentifier)
  returns bit
as
  /*
  Returns true if user has been granted and not denied the form 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_FORM (nolock)
    where APPUSERID = @APPUSERID
    and DATAFORMINSTANCECATALOGID=@FORMID 
    order by GRANTORDENY ASC;

    return @GRANT;
end