fnUserCanEditObjects

            CREATE function [dbo].[fnUserCanEditObjects](@userID int)
            returns bit
            as
            begin
                declare @canEdit bit

                if exists (
                          select 1
                          from dbo.UFN_CLIENTUSERS_SECURITYEXCEPTIONOBJECTS(@userID) EO
                          inner join dbo.CMSOBJETSECURITYEXCEPTION OSE on OSE.EXCEPTIONOBJECTGUID = EO.GUID
                          inner join (select * from dbo.V_CMSSECURABLEOBJECTS where OBJECTTYPEID IN (1, 2, 3, 12, 14, 17, 30, 33)) O on O.OBJECTGUID = OSE.SECUREDOBJECTGUID                
                          inner join dbo.CMSOBJECTTASK OT on OT.ID = OSE.OBJECTTASKID
                          where OT.ENUMID <> 0
                    ) --only use object types that a user could have right to edit via a role they belong to
                    begin
                        set @canedit = 1
                    end
                    else
                    begin
                        set @canedit = 0
                    end

                return @canEdit
            end