V_USAGEREPORT_USERSWITHEDITRIGHTS

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:46 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_USAGEREPORT_USERSWITHEDITRIGHTS AS



                select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE
                    inner join dbo.batchworkflowstate on batchworkflowstate.id = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE.batchworkflowstateid
                    inner join dbo.batchworkflow on batchworkflow.id = batchworkflowstate.batchworkflowid
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE.GRANTORDENY = 1 and not exists(select V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.BATCHTYPECATALOGID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE where V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.GRANTORDENY = 2 and BATCHWORKFLOW.BATCHTYPECATALOGID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.BATCHTYPECATALOGID and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHWORKFLOWSTATE.APPUSERID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.APPUSERID)
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR
                    inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR.BATCHTEMPLATEID
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR.GRANTORDENY = 1 and not exists(select BATCHTYPECATALOGID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE where V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.GRANTORDENY = 2 and BATCHTEMPLATE.BATCHTYPECATALOGID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.BATCHTYPECATALOGID and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHPROCESSOR.APPUSERID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.APPUSERID)
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE
                    inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE.BATCHTEMPLATEID
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE.GRANTORDENY = 1 and not exists(select BATCHTYPECATALOGID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE where V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.GRANTORDENY = 2 and BATCHTEMPLATE.BATCHTYPECATALOGID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.BATCHTYPECATALOGID and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATE.APPUSERID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.APPUSERID)
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER
                    inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER.BATCHTEMPLATEID
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER.GRANTORDENY = 1 and not exists(select BATCHTYPECATALOGID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE where V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.GRANTORDENY = 2 and BATCHTEMPLATE.BATCHTYPECATALOGID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.BATCHTYPECATALOGID and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATEAPPROVER.APPUSERID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.APPUSERID)
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATECUSTOMIZE
                    inner join dbo.BATCHTEMPLATE on BATCHTEMPLATE.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATECUSTOMIZE.BATCHTEMPLATEID
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATECUSTOMIZE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATECUSTOMIZE.GRANTORDENY = 1 and not exists(select BATCHTYPECATALOGID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE where V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.GRANTORDENY = 2 and BATCHTEMPLATE.BATCHTYPECATALOGID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.BATCHTYPECATALOGID and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTEMPLATECUSTOMIZE.APPUSERID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.APPUSERID)
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BATCHTYPE.GRANTORDENY = 1
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.GRANTORDENY = 1
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE
                    inner join dbo.BUSINESSPROCESSINSTANCE on BUSINESSPROCESSINSTANCE.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.BUSINESSPROCESSINSTANCEID
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.GRANTORDENY = 1 and not exists (select V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.BUSINESSPROCESSCATALOGID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS where V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.GRANTORDENY = 2 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.BUSINESSPROCESSCATALOGID = BUSINESSPROCESSINSTANCE.BUSINESSPROCESSCATALOGID and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.APPUSERID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.APPUSERID)
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and ADDPERMISSIONCODE = 1 OR UPDATEPERMISSIONCODE = 1 or DELETEPERMISSIONCODE = 1
                union
                    select APPUSERID from V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE
                    inner join dbo.BUSINESSPROCESSINSTANCE on BUSINESSPROCESSINSTANCE.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.BUSINESSPROCESSINSTANCEID
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.GRANTORDENY = 1 and not exists (select V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.BUSINESSPROCESSCATALOGID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS where V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.GRANTORDENY = 2 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.BUSINESSPROCESSCATALOGID = BUSINESSPROCESSINSTANCE.BUSINESSPROCESSCATALOGID and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESSINSTANCE.APPUSERID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_BUSINESSPROCESS.APPUSERID)
                union
                    select APPUSERID from V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_CODETABLE.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and ADDPERMISSIONCODE = 1 OR UPDATEPERMISSIONCODE = 1 or DELETEPERMISSIONCODE = 1
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM
                    inner join dbo.DATAFORMINSTANCECATALOG on DATAFORMINSTANCECATALOG.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM.DATAFORMINSTANCECATALOGID
                    inner join dbo.DATAFORMTEMPLATECATALOG on DATAFORMTEMPLATECATALOG.ID = DATAFORMINSTANCECATALOG.DATAFORMTEMPLATECATALOGID
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and DATAFORMTEMPLATECATALOG.MODE <> 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_FORM.GRANTORDENY = 1
                union
                    select APPUSERID from dbo.V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION
                    inner join dbo.APPUSER on APPUSER.ID = V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION.APPUSERID
                    where APPUSER.ISSYSADMIN = 0 and V_SECURITY_SYSTEMROLEASSIGNMENT_USER_RECORDOPERATION.GRANTORDENY = 1