UFN_SECURITY_APPUSER_GRANTED_QUERYVIEW_IN_NONRACROLE

CREATE function BBDW.[UFN_SECURITY_APPUSER_GRANTED_QUERYVIEW_IN_NONRACROLE]
   (  
   @APPUSERID uniqueidentifier,  
   @QUERYVIEWCATALOGID uniqueidentifier  
   )  
   returns bit as  

   /*  
   Returns true if the given user has permissions to the given query view  
   in a role whose security group is blank  

   This function is optimized for use from the Blackbaud.AppFx.Security.Catalog.ConstitRecordSecurityService  
   class which implements the RecordSecurity service for Constituent record security.  

   As such, it assumes that a check for DENY occurs outside this function  
   and also assumes that a check for if the user is ISSYSADMIN occurs outside   
   this function.    
   */  


   begin  
   --If user granted permission to the feature in a role with no ringfence then   
   --the user has permission regardless of the record in question.  
   if exists  
    (  
     select   
      1   
     from   
      BBDW.[V_SECURITY_SYSTEMROLEASSIGNMENT_USER_QUERYVIEW] as sv  
     where  
      sv.[APPUSERID] = @APPUSERID and 
      sv.[QUERYVIEWCATALOGID] = @QUERYVIEWCATALOGID and 
      sv.[GRANTORDENY] = 1 and 
      sv.[CONSTITUENTSECURITYMODE] = 0  
    )  
    return 1;  

   return  0;  

   end;