It looks like the follow SQL is part of the problem.
It gets executed 3-6 times for a single page load, and the duration is 280000.
It doesn't run unless the user is authenticated.
Anyone know what this is from?


if exists (select * from dbo.sysusers where name='MY_SQL_USERNAME')
begin
 declare @exec
 nvarchar(2000)
 declare @name varchar(150)
 declare sp_cursor cursor for select o.name as name
   from dbo.sysobjects o
   where ( OBJECTPROPERTY(o.id, N'IsProcedure') = 1 or OBJECTPROPERTY(o.id, N'IsExtendedProc') = 1 or OBJECTPROPERTY(o.id, N'IsReplProc') = 1 ) 
   and OBJECTPROPERTY(o.id, N'IsMSShipped') = 0 and o.name not like N'#%%' and (left(o.name,len('')) = '' or left(o.name,7) = 'aspnet_') open
 fetch sp_cursor into @name
 while @@fetch_status >= 0
   begin
     select @exec = 'grant EXECUTE on ' + @name + ' to [MY_SQL_USERNAME]'
    execute (@exec)
    fetch sp_cursor into @name
   end
 deallocate sp_cursor
end

I'm not sure why it is running that line over and over, but after turning on more detail in SQL Profiler trace, I see that also on every single page load it is granting EXECUTE permissions to every SP in my database to the site's SQL user.

For Example image the following statement for every single stored procedure in my database:
grant EXECUTE on GetTabPermissionsByPortal to [MY_SITE'S_SQL_USERNAME]

Again, this only happens if the user is authenticated, and after to upgrade to DNN 5 from DNN 4.9.4