In that case, then I have already done what you asked. Just for this post, I will repeat the steps and document everything:

1. Extract the contents of the 5.5 compiled code into a directory.
2. Use IIS to configure directory as a web app running with a .NET 4.0 app pool.
3. Create a new empty database in SQL Server 2008 R2.
4. Create a new SQL login named 'dnnuser'. Add user to sysadmin server role. Map the user to new database, add him to db_owner role, and enter 'dnnuser' as the default schema for the user in this database.
5. Open web.config. Update both connection strings to point to new db and specify newly created user. Replace 'dbo' in the databaseOwner attribute with 'dnnuser'.
6. Start install wizard in browser. On 'Configure Database Connection' screen, all I had to do was enter the password for the 'dnnuser' account, since my previous edit of web.config had configured the other options.
7. After clicking Next the following error occurs while running the 5.00.00 SQL script:

Installing Database - Version 05.00.00...FAILURE ERROR: See D:\Development\dnn5.5\Providers\DataProviders\SqlDataProvider\05.00.00.log.resources for more information

The log files contain the same error I mentioned in my previous post:
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'GetTabPanes', because it does not exist or you do not have permission.

See screen shot of my 'dnnuser' configuration in SQL Server.
See screen shot of the SQL Configuration page in the DNN install wizard.

What am I doing wrong?

Thanks,
Roger

I started over, following your exact instructions. After selecting 'Auto' and clicking next, the following appeared:

Installing DotNetNuke
Version: 05.05.00

Installation Status Report
00:00:00.017 - Installing Version: 05.00.00
00:00:00.020 -   Executing Script: DotNetNuke.Schema.SqlDataProvider Error! (see DotNetNuke.Schema.log.resources for more information)
00:00:02.206 -   Executing Script: DotNetNuke.Data.SqlDataProvider Error! (see DotNetNuke.Data.log.resources for more information)
00:00:02.978 - Installing MemberRole Provider:
00:00:02.980 -   Executing Script: InstallCommon
00:00:03.523 -   Executing Script: InstallMembership
00:00:03.955 -   Executing Script: InstallProfile
00:00:04.287 -   Executing Script: InstallRoles
00:00:04.655 - Upgrading to Version: 05.05.00
00:00:04.674 -   Executing Script: 05.00.01.SqlDataProvider Error! (see 05.00.01.log.resources for more information)
00:00:05.224 -   Executing Script: 05.01.00.SqlDataProvider Error! (see 05.01.00.log.resources for more information)
00:00:07.517 -   Executing Script: 05.01.01.SqlDataProvider Error! (see 05.01.01.log.resources for more information)
00:00:07.945 -   Executing Script: 05.01.02.SqlDataProvider Error! (see 05.01.02.log.resources for more information)
00:00:08.168 -   Executing Script: 05.01.03.SqlDataProvider Error! (see 05.01.03.log.resources for more information)
00:00:08.387 -   Executing Script: 05.01.04.SqlDataProvider Error! (see 05.01.04.log.resources for more information)
00:00:08.553 -   Executing Script: 05.02.00.SqlDataProvider Error! (see 05.02.00.log.resources for more information)
00:00:09.253 -   Executing Script: 05.02.01.SqlDataProvider Error! (see 05.02.01.log.resources for more information)
00:00:09.474 -   Executing Script: 05.02.02.SqlDataProvider Error! (see 05.02.02.log.resources for more information)
00:00:09.648 -   Executing Script: 05.02.03.SqlDataProvider Error! (see 05.02.03.log.resources for more information)
00:00:09.849 -   Executing Script: 05.03.00.SqlDataProvider Error! (see 05.03.00.log.resources for more information)
00:00:10.630 -   Executing Script: 05.03.01.SqlDataProvider Error! (see 05.03.01.log.resources for more information)
00:00:10.817 -   Executing Script: 05.04.00.SqlDataProvider Error! (see 05.04.00.log.resources for more information)
00:00:11.297 -   Executing Script: 05.04.01.SqlDataProvider Error! (see 05.04.01.log.resources for more information)
00:00:11.512 -   Executing Script: 05.04.02.SqlDataProvider Error! (see 05.04.02.log.resources for more information)
00:00:11.759 -   Executing Script: 05.04.03.SqlDataProvider Error! (see 05.04.03.log.resources for more information)
00:00:11.948 -   Executing Script: 05.04.04.SqlDataProvider Error! (see 05.04.04.log.resources for more information)
00:00:12.128 -   Executing Script: 05.05.00.SqlDataProvider Error! (see 05.05.00.log.resources for more information)
00:00:13.304 -   Executing Application Upgrades: 05.00.01 Success
00:00:13.624 -   Executing Application Upgrades: 05.01.00 Success
00:00:15.285 -   Executing Application Upgrades: 05.01.01 Success
00:00:15.289 -   Executing Application Upgrades: 05.01.02 Success
00:00:15.289 -   Executing Application Upgrades: 05.01.03 Success
00:00:15.594 -   Executing Application Upgrades: 05.01.04 Success
00:00:15.594 -   Executing Application Upgrades: 05.02.00 Success
00:00:15.661 -   Executing Application Upgrades: 05.02.01 Success
00:00:15.673 -   Executing Application Upgrades: 05.02.02 Success
00:00:15.673 -   Executing Application Upgrades: 05.02.03 Success
00:00:15.673 -   Executing Application Upgrades: 05.03.00 Success
00:00:15.958 -   Executing Application Upgrades: 05.03.01 Success
00:00:15.958 -   Executing Application Upgrades: 05.04.00 Success
00:00:16.125 -   Executing Application Upgrades: 05.04.01 Success
00:00:16.125 -   Executing Application Upgrades: 05.04.02 Success
00:00:16.125 -   Executing Application Upgrades: 05.04.03 Success
00:00:16.127 -   Executing Application Upgrades: 05.04.04 Success
00:00:16.127 -   Executing Application Upgrades: 05.05.00 Success
00:00:16.418 -   Cleaning Up Files: 05.00.01 Success
00:00:16.425 -   Cleaning Up Files: 05.01.00 Success
00:00:16.426 -   Cleaning Up Files: 05.01.01 Success
00:00:16.426 -   Cleaning Up Files: 05.01.02 Success
00:00:16.427 -   Cleaning Up Files: 05.01.03 Success
00:00:16.427 -   Cleaning Up Files: 05.01.04 Success
00:00:16.427 -   Cleaning Up Files: 05.02.00 Success
00:00:16.427 -   Cleaning Up Files: 05.02.01 Success
00:00:16.427 -   Cleaning Up Files: 05.02.02 Success
00:00:16.427 -   Cleaning Up Files: 05.02.03 Success
00:00:16.427 -   Cleaning Up Files: 05.03.00 Success
00:00:16.428 -   Cleaning Up Files: 05.03.01 Success
00:00:16.428 -   Cleaning Up Files: 05.04.00 Success
00:00:16.428 -   Cleaning Up Files: 05.04.01 Success
00:00:16.428 -   Cleaning Up Files: 05.04.02 Success
00:00:16.428 -   Cleaning Up Files: 05.04.03 Success
00:00:16.428 -   Cleaning Up Files: 05.04.04 Success
00:00:16.431 -   Cleaning Up Files: 05.05.00 Success
00:00:16.434 -   Updating Config Files: 05.00.01 Success
00:00:16.439 -   Updating Config Files: 05.01.00 Success
00:00:16.455 -   Updating Config Files: 05.01.01 Success
00:00:16.455 -   Updating Config Files: 05.01.02 Success
00:00:16.455 -   Updating Config Files: 05.01.03 Success
00:00:16.456 -   Updating Config Files: 05.01.04 Success
00:00:16.456 -   Updating Config Files: 05.02.00 Success
00:00:16.460 -   Updating Config Files: 05.02.01 Success
00:00:16.466 -   Updating Config Files: 05.02.02 Success
00:00:16.466 -   Updating Config Files: 05.02.03 Success
00:00:16.466 -   Updating Config Files: 05.03.00 Success
00:00:16.480 -   Updating Config Files: 05.03.01 Success
00:00:16.480 -   Updating Config Files: 05.04.00 Success
00:00:16.480 -   Updating Config Files: 05.04.01 Success
00:00:16.480 -   Updating Config Files: 05.04.02 Success
00:00:16.480 -   Updating Config Files: 05.04.03 Success
00:00:16.482 -   Updating Config Files: 05.04.04 Success
00:00:16.482 -   Updating Config Files: 05.05.00 Success
00:00:16.492 - Performing General Upgrades
00:00:16.561 - Loading Host Settings:
00:00:16.679 - Configuring SuperUser:
00:00:16.857 - Synchronizing Host Files:
00:00:17.204 - Executing Additional Scripts:
00:00:17.207 - Installing Optional Modules:
00:00:17.212 -   Installing Package File HTML_Community_05.04.03_Install:  Error!
00:00:17.756 -   Installing Package File Messaging_01.01.00_Install:  Success
00:00:17.855 -   Installing Package File Taxonomy_01.01.00_Install:  Success
00:00:17.951 -   Installing Package File Telerik_05.05.00_Install:  Success
00:00:18.820 - Installing Optional Skins:
00:00:18.821 -   Installing Package File DNN-MinimalExtropySkin_01.00.07_Install:  Success
00:00:20.655 - Installing Optional Containers:
00:00:20.655 -   Installing Package File DNN-MinimalExtropyContainer_01.00.05_Install:  Success
00:00:20.791 - Installing Optional Languages:
00:00:20.791 - Installing Optional Providers:
00:00:20.791 -   Installing Package File AspNetMembershipProvider_05.02.00_Install:  Success
00:00:20.826 -   Installing Package File CorePermissionProvider_05.01.01_Install:  Success
00:00:20.879 -   Installing Package File CoreSitemapProvider_5.5.0.0_Install:  Success
00:00:20.937 -   Installing Package File DatabaseLoggingProvider_05.01.01_Install:  Success
00:00:20.991 -   Installing Package File DNNMembershipProvider_05.01.03_Install:  Success
00:00:21.053 -   Installing Package File DNNMenuNavigationProvider_05.01.00_Install:  Success
00:00:21.099 -   Installing Package File DNNTreeNavigationProvider_05.01.00_Install:  Success
00:00:21.145 -   Installing Package File FckHtmlEditorProvider_02.00.04_Install:  Success
00:00:23.328 -   Installing Package File FileBasedCachingProvider_05.01.03_Install:  Success
00:00:23.379 -   Installing Package File FileModuleCachingProvider_05.04.03_Install:  Success
00:00:23.486 -   Installing Package File MemoryModuleCachingProvider_05.02.01_Install:  Success
00:00:23.691 -   Installing Package File SchedulingProvider_05.02.01_Install:  Success
00:00:23.874 -   Installing Package File SearchIndexProvider_05.01.00_Install:  Success
00:00:24.015 -   Installing Package File SearchProvider_05.01.01_Install:  Success
00:00:24.084 -   Installing Package File SolpartMenuNavigationProvider_05.01.00_Install:  Success
00:00:24.164 -   Installing Package File TelerikEditorProvider_05.04.02_Install:  Success
00:00:24.452 - Installing Optional AuthSystems:
00:00:24.453 -   Installing Package File LiveID_01.00.01_Install:  Success
00:00:24.532 -   Installing Package File OpenID_02.00.00_Install:  Success
00:00:24.656 - Installing Optional Packages:
00:00:24.664 -   Creating Portal: My Website
00:00:29.011 -   Successfully Installed Portal 0:
Installation Complete

Several of the log files had the same error message in the first line:
System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'GetTabPanes', because it does not exist or you do not have permission.

Details
* I specified the name of the server (RDOG) in the connection string instead of (local).
* I gave the following users/groups 'Full' NTFS permission in Windows Explorer: DefaultAppPool, IUSR, IIS_IUSRS, Everyone. (Giving the Everyone group full permission should eliminate any permission issues.)

For completeness, here are the contents of the log file 05.00.01.log.resources:

System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'GetTabPanes', because it does not exist or you do not have permission.
Cannot find the object 'UpdateFolder', because it does not exist or you do not have permission.
Cannot find the object 'DeletePortalDesktopModules', because it does not exist or you do not have permission.
Cannot find the object 'UpdateEventLogPendingNotif', because it does not exist or you do not have permission.
Cannot find the object 'UpdateUserRole', because it does not exist or you do not have permission.
Cannot find the object 'GetRolesByGroup', because it does not exist or you do not have permission.
Cannot find the object 'UpdateDatabaseVersion', because it does not exist or you do not have permission.
Cannot find the object 'GetRole', because it does not exist or you do not have permission.
Cannot find the object 'DeleteRole', because it does not exist or you do not have permission.
Cannot find the object 'UpdateDatabaseVersionAndName', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSystemMessage', because it does not exist or you do not have permission.
Cannot find the object 'GetTabByName', because it does not exist or you do not have permission.
Cannot find the object 'GetAuthenticationServiceByPackageID', because it does not exist or you do not have permission.
Cannot find the object 'UpdateBanner', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSchedule', because it does not exist or you do not have permission.
Cannot find the object 'AddSearchItemWord', because it does not exist or you do not have permission.
Cannot find the object 'DeleteVendor', because it does not exist or you do not have permission.
Cannot find the object 'GetAllFiles', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchItems', because it does not exist or you do not have permission.
Cannot find the object 'DeleteList', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchWords', because it does not exist or you do not have permission.
Cannot find the object 'dnnLinks_AddLink', because it does not exist or you do not have permission.
Cannot find the object 'ListSearchItemWordPosition', because it does not exist or you do not have permission.
Cannot find the object 'DeleteUrl', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleControls', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchItemWordBySearchWord', because it does not exist or you do not have permission.
Cannot find the object 'UpdateVendor', because it does not exist or you do not have permission.
Cannot find the object 'DeletePermission', because it does not exist or you do not have permission.
Cannot find the object 'DeleteTabModule', because it does not exist or you do not have permission.
Cannot find the object 'DeleteFolderPermissionsByUserID', because it does not exist or you do not have permission.
Cannot find the object 'AddEventLogConfig', because it does not exist or you do not have permission.
Cannot find the object 'ListSearchItemWord', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleControl', because it does not exist or you do not have permission.
Cannot find the object 'GetPropertyDefinition', because it does not exist or you do not have permission.
Cannot find the object 'DeleteRoleGroup', because it does not exist or you do not have permission.
Cannot find the object 'GetPackageTypes', because it does not exist or you do not have permission.
Cannot find the object 'GetEventLogPendingNotif', because it does not exist or you do not have permission.
Cannot find the object 'UpdateEventLogType', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModuleSettings', because it does not exist or you do not have permission.
Cannot find the object 'UpdateUserProfileProperty', because it does not exist or you do not have permission.
Cannot find the object 'GetScheduleHistory', because it does not exist or you do not have permission.
Cannot find the object 'GetFiles', because it does not exist or you do not have permission.
Cannot find the object 'GetBanner', because it does not exist or you do not have permission.
Cannot find the object 'DeleteUserRole', because it does not exist or you do not have permission.
Cannot find the object 'GetLists', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalDesktopModules', because it does not exist or you do not have permission.
Cannot find the object 'UpdateModuleDefinition', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalByPortalAliasID', because it does not exist or you do not have permission.
Cannot find the object 'GetPackages', because it does not exist or you do not have permission.
Cannot find the object 'GetUserByUsername', because it does not exist or you do not have permission.
Cannot find the object 'UpdateEventLogConfig', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModulePermission', because it does not exist or you do not have permission.
Cannot find the object 'UpdateUrlTracking', because it does not exist or you do not have permission.
Cannot find the object 'GetVendorsByEmail', because it does not exist or you do not have permission.
Cannot find the object 'GetHtmlText', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSearchItemWords', because it does not exist or you do not have permission.
Cannot find the object 'UpdateHostSetting', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_AddControl', because it does not exist or you do not have permission.
Cannot find the object 'GetUserRolesByUsername', because it does not exist or you do not have permission.
Cannot find the object 'UpdateModuleControl', because it does not exist or you do not have permission.
Cannot find the object 'GetFolderPermission', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_DeleteControl', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchIndexers', because it does not exist or you do not have permission.
Cannot find the object 'UpdateRole', because it does not exist or you do not have permission.
Cannot find the object 'DeleteListEntryByID', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_GetDashboardControlByKey', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog9', because it does not exist or you do not have permission.
Cannot find the object 'DeleteTabPermissionsByTabID', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_UpdateControl', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog8', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchItemWordPosition', because it does not exist or you do not have permission.
Cannot find the object 'AddModulePermission', because it does not exist or you do not have permission.
Cannot find the object 'GetPermissionsByFolder', because it does not exist or you do not have permission.
Cannot find the object 'AddSkinControl', because it does not exist or you do not have permission.
Cannot find the object 'VerifyPortal', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModule', because it does not exist or you do not have permission.
Cannot find the object 'GetPermissionsByTab', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog3', because it does not exist or you do not have permission.
Cannot find the object 'UpdateProfile', because it does not exist or you do not have permission.
Cannot find the object 'UpdateModuleOrder', because it does not exist or you do not have permission.
Cannot find the object 'GetPermissionsByPortalDesktopModule', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog2', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog12', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog1', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePortalSetup', because it does not exist or you do not have permission.
Cannot find the object 'GetTabModules', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog7', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalAlias', because it does not exist or you do not have permission.
Cannot find the object 'GetModule', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog6', because it does not exist or you do not have permission.
Cannot find the object 'GetPortal', because it does not exist or you do not have permission.
Cannot find the object 'GetEventLogType', because it does not exist or you do not have permission.
Cannot find the object 'UpdateServer', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog5', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSearchItemWordPosition', because it does not exist or you do not have permission.
Cannot find the object 'GetModulePermissionsByModuleID', because it does not exist or you do not have permission.
Cannot find the object 'GetSkinPackage', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSearchWord', because it does not exist or you do not have permission.
Cannot find the object 'GetUser', because it does not exist or you do not have permission.
Cannot find the object 'GetBannerGroups', because it does not exist or you do not have permission.
Cannot find the object 'AddScheduleItemSetting', because it does not exist or you do not have permission.
Cannot find the object 'GetSkinControls', because it does not exist or you do not have permission.
Cannot find the object 'GetUsers', because it does not exist or you do not have permission.
Cannot find the object 'GetServices', because it does not exist or you do not have permission.
Cannot find the object 'AddSiteLog', because it does not exist or you do not have permission.
Cannot find the object 'AddSystemMessage', because it does not exist or you do not have permission.
Cannot find the object 'DeleteTabPermission', because it does not exist or you do not have permission.
Cannot find the object 'AddEventLog', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchResultModules', because it does not exist or you do not have permission.
Cannot find the object 'AddFile', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalByAlias', because it does not exist or you do not have permission.
Cannot find the object 'GetRoleGroups', because it does not exist or you do not have permission.
Cannot find the object 'GetTabsByParentId', because it does not exist or you do not have permission.
Cannot find the object 'GetPackage', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModulePermission', because it does not exist or you do not have permission.
Cannot find the object 'GetListEntries', because it does not exist or you do not have permission.
Cannot find the object 'GetEventMessagesBySubscriber', because it does not exist or you do not have permission.
Cannot find the object 'GetOnlineUser', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSearchItemWordPosition', because it does not exist or you do not have permission.
Cannot find the object 'RegisterAssembly', because it does not exist or you do not have permission.
Cannot find the object 'UpdateTabModule', because it does not exist or you do not have permission.
Cannot find the object 'AddFolderPermission', because it does not exist or you do not have permission.
Cannot find the object 'GetModulePermissionsByTabID', because it does not exist or you do not have permission.
Cannot find the object 'UpdateTabModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'GetUserCountByPortal', because it does not exist or you do not have permission.
Cannot find the object 'DeleteAuthentication', because it does not exist or you do not have permission.
Cannot find the object 'GetOnlineUsers', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModuleDefinition', because it does not exist or you do not have permission.
Cannot find the object 'AddTab', because it does not exist or you do not have permission.
Cannot find the object 'GetHostSettings', because it does not exist or you do not have permission.
Cannot find the object 'UpdateTab', because it does not exist or you do not have permission.
Cannot find the object 'DeleteFolderPermission', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleDefinition', because it does not exist or you do not have permission.
Cannot find the object 'AddSearchWord', because it does not exist or you do not have permission.
Cannot find the object 'GetFileById', because it does not exist or you do not have permission.
Cannot find the object 'DeletePortalSetting', because it does not exist or you do not have permission.
Cannot find the object 'GetAllTabsModules', because it does not exist or you do not have permission.
Cannot find the object 'AddHostSetting', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSkinControl', because it does not exist or you do not have permission.
Cannot find the object 'UnRegisterAssembly', because it does not exist or you do not have permission.
Cannot find the object 'GetTabPermissionsByTabID', because it does not exist or you do not have permission.
Cannot find the object 'DeleteUserPortal', because it does not exist or you do not have permission.
Cannot find the object 'GetFolderByFolderPath', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModulesByPortal', because it does not exist or you do not have permission.
Cannot find the object 'AddPortalDesktopModule', because it does not exist or you do not have permission.
Cannot find the object 'GetAllUsers', because it does not exist or you do not have permission.
Cannot find the object 'FindDatabaseVersion', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePackage', because it does not exist or you do not have permission.
Cannot find the object 'GetTabPermissionsByPortal', because it does not exist or you do not have permission.
Cannot find the object 'GetUsersByUserName', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSkinPackage', because it does not exist or you do not have permission.
Cannot find the object 'GetAuthenticationService', because it does not exist or you do not have permission.
Cannot find the object 'GetPropertyDefinitionByName', because it does not exist or you do not have permission.
Cannot find the object 'GetUsersByEmail', because it does not exist or you do not have permission.
Cannot find the object 'UpdateListEntry', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSearchItem', because it does not exist or you do not have permission.
Cannot find the object 'GetPermissionByCodeAndKey', because it does not exist or you do not have permission.
Cannot find the object 'GetUsersByRolename', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_GetServerErrors', because it does not exist or you do not have permission.
Cannot find the object 'GetAffiliate', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSkin', because it does not exist or you do not have permission.
Cannot find the object 'DeletePortalAlias', because it does not exist or you do not have permission.
Cannot find the object 'GetUsersByProfileProperty', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_GetInstalledModules', because it does not exist or you do not have permission.
Cannot find the object 'GetDefaultLanguageByModule', because it does not exist or you do not have permission.
Cannot find the object 'UpdateModule', because it does not exist or you do not have permission.
Cannot find the object 'GetSkinControlByPackageID', because it does not exist or you do not have permission.
Cannot find the object 'UpdateUser', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_GetDbInfo', because it does not exist or you do not have permission.
Cannot find the object 'GetLanguagesByPortal', because it does not exist or you do not have permission.
Cannot find the object 'GetSiteLog4', because it does not exist or you do not have permission.
Cannot find the object 'AddLanguage', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchResultsByWord', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_GetDbFileInfo', because it does not exist or you do not have permission.
Cannot find the object 'UpdateFolderPermission', because it does not exist or you do not have permission.
Cannot find the object 'UpdateDesktopModule', because it does not exist or you do not have permission.
Cannot find the object 'AddFolder', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_GetDbBackups', because it does not exist or you do not have permission.
Cannot find the object 'DeleteTabModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalAliasByPortalID', because it does not exist or you do not have permission.
Cannot find the object 'AddProfile', because it does not exist or you do not have permission.
Cannot find the object 'GetModulePermission', because it does not exist or you do not have permission.
Cannot find the object 'GetUserByAuthToken', because it does not exist or you do not have permission.
Cannot find the object 'AddModuleDefinition', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePortalAlias', because it does not exist or you do not have permission.
Cannot find the object 'GetExpiredPortals', because it does not exist or you do not have permission.
Cannot find the object 'GetList', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchItemWord', because it does not exist or you do not have permission.
Cannot find the object 'UpdateAffiliateStats', because it does not exist or you do not have permission.
Cannot find the object 'Dashboard_GetControls', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSearchCommonWord', because it does not exist or you do not have permission.
Cannot find the object 'GetHostSetting', because it does not exist or you do not have permission.
Cannot find the object 'dnnLinks_UpdateLink', because it does not exist or you do not have permission.
Cannot find the object 'DeletePortalSettings', because it does not exist or you do not have permission.
Cannot find the object 'AddUserRole', because it does not exist or you do not have permission.
Cannot find the object 'AddSearchItemWordPosition', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSearchItemWord', because it does not exist or you do not have permission.
Cannot find the object 'dnnLinks_DeleteLink', because it does not exist or you do not have permission.
Cannot find the object 'GetEventLogConfig', because it does not exist or you do not have permission.
Cannot find the object 'GetPackageType', because it does not exist or you do not have permission.
Cannot find the object 'AddHtmlText', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSearchItem', because it does not exist or you do not have permission.
Cannot find the object 'UpdateLanguage', because it does not exist or you do not have permission.
Cannot find the object 'GetUnAuthorizedUsers', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePortalAliasOnInstall', because it does not exist or you do not have permission.
Cannot find the object 'GetScheduleByScheduleID', because it does not exist or you do not have permission.
Cannot find the object 'AddDefaultPropertyDefinitions', because it does not exist or you do not have permission.
Cannot find the object 'GetEventLogPendingNotifConfig', because it does not exist or you do not have permission.
Cannot find the object 'AddLanguagePack', because it does not exist or you do not have permission.
Cannot find the object 'GetPropertyDefinitionsByPortal', because it does not exist or you do not have permission.
Cannot find the object 'GetDatabaseVersion', because it does not exist or you do not have permission.
Cannot find the object 'GetVendorClassifications', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSearchItems', because it does not exist or you do not have permission.
Cannot find the object 'GetSystemMessages', because it does not exist or you do not have permission.
Cannot find the object 'GetAllProfiles', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchModules', because it does not exist or you do not have permission.
Cannot find the object 'DeleteLanguagePack', because it does not exist or you do not have permission.
Cannot find the object 'GetTabModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'DeleteTabModuleSettings', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePropertyDefinition', because it does not exist or you do not have permission.
Cannot find the object 'IsUserInRole', because it does not exist or you do not have permission.
Cannot find the object 'AddUrlTracking', because it does not exist or you do not have permission.
Cannot find the object 'UpdateScheduleHistory', because it does not exist or you do not have permission.
Cannot find the object 'DeleteTab', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleSettings', because it does not exist or you do not have permission.
Cannot find the object 'AddBanner', because it does not exist or you do not have permission.
Cannot find the object 'UpdateHtmlText', because it does not exist or you do not have permission.
Cannot find the object 'GetLanguages', because it does not exist or you do not have permission.
Cannot find the object 'GetRoleGroup', because it does not exist or you do not have permission.
Cannot find the object 'GetScheduleByTypeFullName', because it does not exist or you do not have permission.
Cannot find the object 'AddRoleGroup', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalRoles', because it does not exist or you do not have permission.
Cannot find the object 'GetSkinControl', because it does not exist or you do not have permission.
Cannot find the object 'AddDesktopModule', because it does not exist or you do not have permission.
Cannot find the object 'AddTabPermission', because it does not exist or you do not have permission.
Cannot find the object 'GetTab', because it does not exist or you do not have permission.
Cannot find the object 'AddAffiliate', because it does not exist or you do not have permission.
Cannot find the object 'DeleteFile', because it does not exist or you do not have permission.
Cannot find the object 'GetUserRole', because it does not exist or you do not have permission.
Cannot find the object 'AddModuleControl', because it does not exist or you do not have permission.
Cannot find the object 'GetTables', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleControlsByKey', because it does not exist or you do not have permission.
Cannot find the object 'GetVendorsByName', because it does not exist or you do not have permission.
Cannot find the object 'GetTabModuleOrder', because it does not exist or you do not have permission.
Cannot find the object 'UpdateAuthentication', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModulePermissions', because it does not exist or you do not have permission.
Cannot find the object 'UpdateBannerClickThrough', because it does not exist or you do not have permission.
Cannot find the object 'GetRoleByName', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSkinControl', because it does not exist or you do not have permission.
Cannot find the object 'UpdateAnonymousUser', because it does not exist or you do not have permission.
Cannot find the object 'FindBanners', because it does not exist or you do not have permission.
Cannot find the object 'UpdateFile', because it does not exist or you do not have permission.
Cannot find the object 'AddAuthentication', because it does not exist or you do not have permission.
Cannot find the object 'GetUrls', because it does not exist or you do not have permission.
Cannot find the object 'UpdateListSortOrder', because it does not exist or you do not have permission.
Cannot find the object 'UpdateOnlineUser', because it does not exist or you do not have permission.
Cannot find the object 'AddPortalInfo', because it does not exist or you do not have permission.
Cannot find the object 'SetEventMessageComplete', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalSpaceUsed', because it does not exist or you do not have permission.
Cannot find the object 'DeleteFolder', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSystemMessage', because it does not exist or you do not have permission.
Cannot find the object 'GetSystemMessage', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleDefinitionByName', because it does not exist or you do not have permission.
Cannot find the object 'GetAllTabs', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleControlByKeyAndSrc', because it does not exist or you do not have permission.
Cannot find the object 'CanDeleteSkin', because it does not exist or you do not have permission.
Cannot find the object 'GetVendors', because it does not exist or you do not have permission.
Cannot find the object 'dnnLinks_GetLinks', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalByTab', because it does not exist or you do not have permission.
Cannot find the object 'GetUserProfile', because it does not exist or you do not have permission.
Cannot find the object 'UpdateModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'UpdateAffiliate', because it does not exist or you do not have permission.
Cannot find the object 'PurgeEventLog', because it does not exist or you do not have permission.
Cannot find the object 'DeletePortalInfo', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModulePermissionsByPortalDesktopModuleID', because it does not exist or you do not have permission.
Cannot find the object 'GetProfile', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalAliasByPortalAliasID', because it does not exist or you do not have permission.
Cannot find the object 'AddPortalAlias', because it does not exist or you do not have permission.
Cannot find the object 'AddUser', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchItemWordPositionBySearchItemWord', because it does not exist or you do not have permission.
Cannot find the object 'DeleteFolderPermissionsByFolderPath', because it does not exist or you do not have permission.
Cannot find the object 'GetSuperUsers', because it does not exist or you do not have permission.
Cannot find the object 'AddSkinPackage', because it does not exist or you do not have permission.
Cannot find the object 'AddPortalLanguage', because it does not exist or you do not have permission.
Cannot find the object 'UpdateRoleGroup', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModuleControl', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchWordByID', because it does not exist or you do not have permission.
Cannot find the object 'DeleteEventLogConfig', because it does not exist or you do not have permission.
Cannot find the object 'DeleteDesktopModulePermission', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchItemWordBySearchItem', because it does not exist or you do not have permission.
Cannot find the object 'AddSearchItem', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSkin', because it does not exist or you do not have permission.
Cannot find the object 'AddSkin', because it does not exist or you do not have permission.
Cannot find the object 'GetTabs', because it does not exist or you do not have permission.
Cannot find the object 'DeleteLanguage', because it does not exist or you do not have permission.
Cannot find the object 'DeleteVendorClassifications', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchResults', because it does not exist or you do not have permission.
Cannot find the object 'GetUserRoles', because it does not exist or you do not have permission.
Cannot find the object 'UpdateTabOrder', because it does not exist or you do not have permission.
Cannot find the object 'GetSkinPackageByPackageID', because it does not exist or you do not have permission.
Cannot find the object 'DeletePortalLanguages', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModulePermissionsByModuleID', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchCommonWordByID', because it does not exist or you do not have permission.
Cannot find the object 'GetFolders', because it does not exist or you do not have permission.
Cannot find the object 'GetBanners', because it does not exist or you do not have permission.
Cannot find the object 'AddTabModule', because it does not exist or you do not have permission.
Cannot find the object 'DeleteFiles', because it does not exist or you do not have permission.
Cannot find the object 'UpdateTabPermission', because it does not exist or you do not have permission.
Cannot find the object 'GetVendor', because it does not exist or you do not have permission.
Cannot find the object 'AddVendorClassification', because it does not exist or you do not have permission.
Cannot find the object 'AddPermission', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModulePermissionsByUserID', because it does not exist or you do not have permission.
Cannot find the object 'GetPermissionsByModuleDefID', because it does not exist or you do not have permission.
Cannot find the object 'DeleteDesktopModule', because it does not exist or you do not have permission.
Cannot find the object 'GetTabModuleSettings', because it does not exist or you do not have permission.
Cannot find the object 'AddListEntry', because it does not exist or you do not have permission.
Cannot find the object 'PurgeScheduleHistory', because it does not exist or you do not have permission.
Cannot find the object 'GetFolderPermissionsByFolderPath', because it does not exist or you do not have permission.
Cannot find the object 'GetLanguagePackByPackage', because it does not exist or you do not have permission.
Cannot find the object 'GetPackagesByType', because it does not exist or you do not have permission.
Cannot find the object 'ListSearchItem', because it does not exist or you do not have permission.
Cannot find the object 'dnnLinks_GetLink', because it does not exist or you do not have permission.
Cannot find the object 'AddUserAuthentication', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSearchCommonWord', because it does not exist or you do not have permission.
Cannot find the object 'GetPropertyDefinitionsByCategory', because it does not exist or you do not have permission.
Cannot find the object 'GetModulePermissionsByPortal', because it does not exist or you do not have permission.
Cannot find the object 'DeleteModule', because it does not exist or you do not have permission.
Cannot find the object 'DeleteUsersOnline', because it does not exist or you do not have permission.
Cannot find the object 'GetFile', because it does not exist or you do not have permission.
Cannot find the object 'AddRole', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePortalSetting', because it does not exist or you do not have permission.
Cannot find the object 'GetTabCount', because it does not exist or you do not have permission.
Cannot find the object 'UpdateFileContent', because it does not exist or you do not have permission.
Cannot find the object 'UpdateLanguagePack', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModules', because it does not exist or you do not have permission.
Cannot find the object 'AddEventMessage', because it does not exist or you do not have permission.
Cannot find the object 'AddSchedule', because it does not exist or you do not have permission.
Cannot find the object 'DeleteTabPermissionsByUserID', because it does not exist or you do not have permission.
Cannot find the object 'AddPropertyDefinition', because it does not exist or you do not have permission.
Cannot find the object 'GetPackageByName', because it does not exist or you do not have permission.
Cannot find the object 'GetModules', because it does not exist or you do not have permission.
Cannot find the object 'GetListEntry', because it does not exist or you do not have permission.
Cannot find the object 'VerifyPortalTab', because it does not exist or you do not have permission.
Cannot find the object 'GetAuthenticationServiceByType', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModuleByPackageID', because it does not exist or you do not have permission.
Cannot find the object 'AddUrl', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSkinPackage', because it does not exist or you do not have permission.
Cannot find the object 'GetScheduleNextTask', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalsByName', because it does not exist or you do not have permission.
Cannot find the object 'GetEventMessages', because it does not exist or you do not have permission.
Cannot find the object 'DeletePropertyDefinition', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchCommonWordsByLocale', because it does not exist or you do not have permission.
Cannot find the object 'GetAuthenticationServices', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePermission', because it does not exist or you do not have permission.
Cannot find the object 'GetUrlLog', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSchedule', because it does not exist or you do not have permission.
Cannot find the object 'GetRolesByUser', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSearchItemWord', because it does not exist or you do not have permission.
Cannot find the object 'DeleteSiteLog', because it does not exist or you do not have permission.
Cannot find the object 'GetAllModules', because it does not exist or you do not have permission.
Cannot find the object 'DeleteEventLogType', because it does not exist or you do not have permission.
Cannot find the object 'GetPortals', because it does not exist or you do not have permission.
Cannot find the object 'AddUrlLog', because it does not exist or you do not have permission.
Cannot find the object 'UpdateModulePermission', because it does not exist or you do not have permission.
Cannot find the object 'UpdatePortalInfo', because it does not exist or you do not have permission.
Cannot find the object 'DeleteDesktopModulePermissionsByUserID', because it does not exist or you do not have permission.
Cannot find the object 'GetAffiliates', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchSettings', because it does not exist or you do not have permission.
Cannot find the object 'GetUrl', because it does not exist or you do not have permission.
Cannot find the object 'GetCurrencies', because it does not exist or you do not have permission.
Cannot find the object 'GetFolderPermissionsByPortal', because it does not exist or you do not have permission.
Cannot find the object 'DeleteEventLog', because it does not exist or you do not have permission.
Cannot find the object 'UpdateBannerViews', because it does not exist or you do not have permission.
Cannot find the object 'AddScheduleHistory', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModuleByFriendlyName', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalSettings', because it does not exist or you do not have permission.
Cannot find the object 'AddEventLogType', because it does not exist or you do not have permission.
Cannot find the object 'GetEventLog', because it does not exist or you do not have permission.
Cannot find the object 'GetPermission', because it does not exist or you do not have permission.
Cannot find the object 'GetFolderByFolderID', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleByDefinition', because it does not exist or you do not have permission.
Cannot find the object 'GetSchedule', because it does not exist or you do not have permission.
Cannot find the object 'DeleteAffiliate', because it does not exist or you do not have permission.
Cannot find the object 'GetPortalCount', because it does not exist or you do not have permission.
Cannot find the object 'DeletePackage', because it does not exist or you do not have permission.
Cannot find the object 'AddTabModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'UpdateUrlTrackingStats', because it does not exist or you do not have permission.
Cannot find the object 'AddPackage', because it does not exist or you do not have permission.
Cannot find the object 'GetTabPermission', because it does not exist or you do not have permission.
Cannot find the object 'AddDesktopModulePermission', because it does not exist or you do not have permission.
Cannot find the object 'UpdateSearchWord', because it does not exist or you do not have permission.
Cannot find the object 'GetScheduleItemSettings', because it does not exist or you do not have permission.
Cannot find the object 'AddVendor', because it does not exist or you do not have permission.
Cannot find the object 'GetModuleDefinitions', because it does not exist or you do not have permission.
Cannot find the object 'AddModuleSetting', because it does not exist or you do not have permission.
Cannot find the object 'DeleteBanner', because it does not exist or you do not have permission.
Cannot find the object 'AddSearchCommonWord', because it does not exist or you do not have permission.
Cannot find the object 'GetScheduleByEvent', because it does not exist or you do not have permission.
Cannot find the object 'GetFileContent', because it does not exist or you do not have permission.
Cannot find the object 'DeleteUrlTracking', because it does not exist or you do not have permission.
Cannot find the object 'GetSkinControlByKey', because it does not exist or you do not have permission.
Cannot find the object 'GetUrlTracking', because it does not exist or you do not have permission.
Cannot find the object 'GetRoles', because it does not exist or you do not have permission.
Cannot find the object 'GetSearchItem', because it does not exist or you do not have permission.
Cannot find the object 'GetEventLogByLogGUID', because it does not exist or you do not have permission.
Cannot find the object 'GetPermissionsByModuleID', because it does not exist or you do not have permission.
Cannot find the object 'GetEnabledAuthenticationServices', because it does not exist or you do not have permission.
Cannot find the object 'GetDesktopModuleByModuleName', because it does not exist or you do not have permission.
Cannot find the object 'DeleteDesktopModulePermissionsByPortalDesktopModuleID', because it does not exist or you do not have permission.
Cannot find the object 'GetRoleGroupByName', because it does not exist or you do not have permission.
Cannot find the object 'AddModule', because it does not exist or you do not have permission.
Cannot find the object 'UpdateDesktopModulePermission', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at DotNetNuke.Data.SqlDataProvider.GrantStoredProceduresPermission(String Permission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='dnnuser')  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 sp_cursor     fetch sp_cursor into @name     while @@fetch_status >= 0       begin        select @exec = 'grant EXECUTE on [' +  @name  + '] to [dnnuser]'        execute (@exec)        fetch sp_cursor into @name       end     deallocate sp_cursor  end

System.Data.SqlClient.SqlException (0x80131904): Cannot find the object 'GetListParentKey', because it does not exist or you do not have permission.
Cannot find the object 'GetElement', because it does not exist or you do not have permission.
Cannot find the object 'GetProfilePropertyDefinitionID', because it does not exist or you do not have permission.
Cannot find the object 'GetProfileElement', because it does not exist or you do not have permission.
Cannot find the object 'fn_GetVersion', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)
   at DotNetNuke.Data.SqlDataProvider.GrantUserDefinedFunctionsPermission(String ScalarPermission, String TablePermission, String LoginOrRole)

if exists (select * from dbo.sysusers where name='dnnuser')  begin    declare @exec nvarchar(2000)     declare @name varchar(150)     declare @isscalarfunction int     declare @istablefunction int     declare sp_cursor cursor for select o.name as name, OBJECTPROPERTY(o.id, N'IsScalarFunction') as IsScalarFunction     from dbo.sysobjects o     where ( OBJECTPROPERTY(o.id, N'IsScalarFunction') = 1 OR OBJECTPROPERTY(o.id, N'IsTableFunction') = 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 sp_cursor     fetch sp_cursor into @name, @isscalarfunction     while @@fetch_status >= 0       begin         if @IsScalarFunction = 1           begin            select @exec = 'grant EXECUTE on [' +  @name  + '] to [dnnuser]'            execute (@exec)            fetch sp_cursor into @name, @isscalarfunction            end         else           begin            select @exec = 'grant SELECT on [' +  @name  + '] to [dnnuser]'            execute (@exec)            fetch sp_cursor into @name, @isscalarfunction            end       end     deallocate sp_cursor  end