New and upgraded CS 2008 databases -- missing all permissions for stored procedures

Reply

davestechshop Posted: Wed, May 28 2008 5:51 PM

rated by 0 users

My CS 2008 database is missing all permissions for stored procedures. In the properties > permissions pane for every stored procedure I have checked, the permissions are blank. (Not even public is granted any permissions.)

This is true for both a clean install as well as for my upgraded database. Can anyone tell me how to resolve this?

(I originally uncovered this problem in this post: http://dev.communityserver.com/forums/p/499738/622375.aspx#622375 but this issue really belongs in a separate thread, so here it is.)

Would anyone care to remind me what the SQL code is to grant execute permission to public on all the stored procedures in my upgraded CS 2008 database? Is it a good idea attempt to resolve this issue by running a script to grant permissions on all stored procedures?

Looking forward to any feedback. Thanks.

Reply

davestechshop replied on Wed, May 28 2008 8:08 PM

rated by 0 users

This post reminded me how to grant execute permission to public on all the stored procedures.

My question remains, however, should I do that? In particular, should I grant public execute permissions to all the aspnet_ procedures? Thanks.

Reply

davestechshop replied on Wed, May 28 2008 8:20 PM

rated by 0 users

If anyone else wants it, here is the script. I would still like to know if all these procedures should be included.

Grant exec on [dbo].[aspnet_AnyDataInTables] TO [Public]
Grant exec on [dbo].[aspnet_Applications_CreateApplication] TO [Public]
Grant exec on [dbo].[aspnet_CheckSchemaVersion] TO [Public]
Grant exec on [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] TO [Public]
Grant exec on [dbo].[aspnet_Membership_CreateUser] TO [Public]
Grant exec on [dbo].[aspnet_Membership_FindUsersByEmail] TO [Public]
Grant exec on [dbo].[aspnet_Membership_FindUsersByName] TO [Public]
Grant exec on [dbo].[aspnet_Membership_GetAllUsers] TO [Public]
Grant exec on [dbo].[aspnet_Membership_GetNumberOfUsersOnline] TO [Public]
Grant exec on [dbo].[aspnet_Membership_GetPassword] TO [Public]
Grant exec on [dbo].[aspnet_Membership_GetPasswordWithFormat] TO [Public]
Grant exec on [dbo].[aspnet_Membership_GetUserByEmail] TO [Public]
Grant exec on [dbo].[aspnet_Membership_GetUserByName] TO [Public]
Grant exec on [dbo].[aspnet_Membership_GetUserByUserId] TO [Public]
Grant exec on [dbo].[aspnet_Membership_ResetPassword] TO [Public]
Grant exec on [dbo].[aspnet_Membership_SetPassword] TO [Public]
Grant exec on [dbo].[aspnet_Membership_UnlockUser] TO [Public]
Grant exec on [dbo].[aspnet_Membership_UpdateUser] TO [Public]
Grant exec on [dbo].[aspnet_Membership_UpdateUserInfo] TO [Public]
Grant exec on [dbo].[aspnet_Paths_CreatePath] TO [Public]
Grant exec on [dbo].[aspnet_Personalization_GetApplicationId] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAdministration_FindState] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAdministration_ResetUserState] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] TO [Public]
Grant exec on [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] TO [Public]
Grant exec on [dbo].[aspnet_Profile_DeleteInactiveProfiles] TO [Public]
Grant exec on [dbo].[aspnet_Profile_DeleteProfiles] TO [Public]
Grant exec on [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] TO [Public]
Grant exec on [dbo].[aspnet_Profile_GetProfiles] TO [Public]
Grant exec on [dbo].[aspnet_Profile_GetProperties] TO [Public]
Grant exec on [dbo].[aspnet_Profile_SetProperties] TO [Public]
Grant exec on [dbo].[aspnet_RegisterSchemaVersion] TO [Public]
Grant exec on [dbo].[aspnet_Roles_CreateRole] TO [Public]
Grant exec on [dbo].[aspnet_Roles_DeleteRole] TO [Public]
Grant exec on [dbo].[aspnet_Roles_GetAllRoles] TO [Public]
Grant exec on [dbo].[aspnet_Roles_RoleExists] TO [Public]
Grant exec on [dbo].[aspnet_Setup_RemoveAllRoleMembers] TO [Public]
Grant exec on [dbo].[aspnet_Setup_RestorePermissions] TO [Public]
Grant exec on [dbo].[aspnet_UnRegisterSchemaVersion] TO [Public]
Grant exec on [dbo].[aspnet_Users_CreateUser] TO [Public]
Grant exec on [dbo].[aspnet_Users_DeleteUser] TO [Public]
Grant exec on [dbo].[aspnet_UsersInRoles_AddUsersToRoles] TO [Public]
Grant exec on [dbo].[aspnet_UsersInRoles_FindUsersInRole] TO [Public]
Grant exec on [dbo].[aspnet_UsersInRoles_GetRolesForUser] TO [Public]
Grant exec on [dbo].[aspnet_UsersInRoles_GetUsersInRoles] TO [Public]
Grant exec on [dbo].[aspnet_UsersInRoles_IsUserInRole] TO [Public]
Grant exec on [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] TO [Public]
Grant exec on [dbo].[aspnet_WebEvent_LogEvent] TO [Public]
Grant exec on [dbo].[cs_ApiKeys_Create] TO [Public]
Grant exec on [dbo].[cs_ApiKeys_Delete] TO [Public]
Grant exec on [dbo].[cs_ApiKeys_Get] TO [Public]
Grant exec on [dbo].[cs_ApiKeys_Update] TO [Public]
Grant exec on [dbo].[cs_ApplicationConfigurationSettings_CreateUpdate] TO [Public]
Grant exec on [dbo].[cs_ApplicationConfigurationSettings_Get] TO [Public]
Grant exec on [dbo].[cs_Audit_Post] TO [Public]
Grant exec on [dbo].[cs_BannedAddress_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_BannedAddresses_Get] TO [Public]
Grant exec on [dbo].[cs_BannedNetwork_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_BannedNetworks_Get] TO [Public]
Grant exec on [dbo].[cs_BlogActivityNightlyJob] TO [Public]
Grant exec on [dbo].[cs_Censorship_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Censorships_Get] TO [Public]
Grant exec on [dbo].[cs_ConfigurableAddonData_CreateUpdate] TO [Public]
Grant exec on [dbo].[cs_ConfigurableAddonData_Get] TO [Public]
Grant exec on [dbo].[cs_Content_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Content_GetList] TO [Public]
Grant exec on [dbo].[cs_Content_Load] TO [Public]
Grant exec on [dbo].[cs_Content_UpdateDate] TO [Public]
Grant exec on [dbo].[cs_DisallowedName_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_DisallowedNames_Get] TO [Public]
Grant exec on [dbo].[cs_EmailQueue_Delete] TO [Public]
Grant exec on [dbo].[cs_EmailQueue_Failure] TO [Public]
Grant exec on [dbo].[cs_Emails_Dequeue] TO [Public]
Grant exec on [dbo].[cs_Emails_Enqueue] TO [Public]
Grant exec on [dbo].[cs_Emails_SubscribedSection] TO [Public]
Grant exec on [dbo].[cs_Emails_TrackingSection] TO [Public]
Grant exec on [dbo].[cs_Emails_TrackingThread] TO [Public]
Grant exec on [dbo].[cs_es_Search_Queue_Get] TO [Public]
Grant exec on [dbo].[cs_es_Search_QueueManager] TO [Public]
Grant exec on [dbo].[cs_EventLog_Add] TO [Public]
Grant exec on [dbo].[cs_EventLog_Clear] TO [Public]
Grant exec on [dbo].[cs_EventLog_GetEntries] TO [Public]
Grant exec on [dbo].[cs_EventLog_GetEntry] TO [Public]
Grant exec on [dbo].[cs_Exceptions_Get] TO [Public]
Grant exec on [dbo].[cs_Exceptions_Log] TO [Public]
Grant exec on [dbo].[cs_Favorite_Add] TO [Public]
Grant exec on [dbo].[cs_Favorite_Delete] TO [Public]
Grant exec on [dbo].[cs_Favorite_Get] TO [Public]
Grant exec on [dbo].[cs_Favorite_GetByUserItem] TO [Public]
Grant exec on [dbo].[cs_Favorites_Get] TO [Public]
Grant exec on [dbo].[cs_Favorites_GetPosts] TO [Public]
Grant exec on [dbo].[cs_Favorites_GetSections] TO [Public]
Grant exec on [dbo].[cs_Favorites_GetUsers] TO [Public]
Grant exec on [dbo].[cs_Favorites_GetUsersWatching] TO [Public]
Grant exec on [dbo].[cs_forums_GetForumMessages] TO [Public]
Grant exec on [dbo].[cs_forums_GetForumModerators] TO [Public]
Grant exec on [dbo].[cs_forums_GetForumsModeratedByUser] TO [Public]
Grant exec on [dbo].[cs_forums_GetForumsNotModeratedByUser] TO [Public]
Grant exec on [dbo].[cs_forums_GetUnmoderatedPostStatus] TO [Public]
Grant exec on [dbo].[cs_forums_Moderate_PostSet] TO [Public]
Grant exec on [dbo].[cs_forums_Post] TO [Public]
Grant exec on [dbo].[cs_forums_Posts_PostSet] TO [Public]
Grant exec on [dbo].[cs_forums_Thread_Get] TO [Public]
Grant exec on [dbo].[cs_forums_threads_ThreadsRead] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_Delete] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_DeleteByID] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_Insert] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_Save] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_SelectBetweenUsers] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_SelectByID] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_SelectByRequesteeUserID] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_SelectByRequestorUserID] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_SelectByUserID] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_Update] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_UpdateByID] TO [Public]
Grant exec on [dbo].[cs_FriendRequest_xref_Insert] TO [Public]
Grant exec on [dbo].[cs_GetSectionsForUserSubscriptions] TO [Public]
Grant exec on [dbo].[cs_GetSectionSubscriptionType] TO [Public]
Grant exec on [dbo].[cs_GetSectionSubscriptionTypes] TO [Public]
Grant exec on [dbo].[cs_GetTotalPostCount] TO [Public]
Grant exec on [dbo].[cs_GetUserIDByAppToken] TO [Public]
Grant exec on [dbo].[cs_GetUsersForSectionSubscriptions] TO [Public]
Grant exec on [dbo].[cs_Group_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Group_Permissions_Get] TO [Public]
Grant exec on [dbo].[cs_Groups_Get] TO [Public]
Grant exec on [dbo].[cs_Groups_ReOrder] TO [Public]
Grant exec on [dbo].[cs_Groups_ResetOrder] TO [Public]
Grant exec on [dbo].[cs_guestbook_GetPosts] TO [Public]
Grant exec on [dbo].[cs_guestbook_Post_Create] TO [Public]
Grant exec on [dbo].[cs_guestbook_Post_Delete] TO [Public]
Grant exec on [dbo].[cs_InkData_Add] TO [Public]
Grant exec on [dbo].[cs_InkData_Delete] TO [Public]
Grant exec on [dbo].[cs_InkData_Get] TO [Public]
Grant exec on [dbo].[cs_InkData_Update] TO [Public]
Grant exec on [dbo].[cs_Licenses_Delete] TO [Public]
Grant exec on [dbo].[cs_Licenses_Get] TO [Public]
Grant exec on [dbo].[cs_Licenses_GetUsage] TO [Public]
Grant exec on [dbo].[cs_Licenses_Update] TO [Public]
Grant exec on [dbo].[cs_Link_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Link_UpdateSortOrder] TO [Public]
Grant exec on [dbo].[cs_LinkCategories_Get] TO [Public]
Grant exec on [dbo].[cs_LinkCategory_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_LinkCategory_UpdateSortOrder] TO [Public]
Grant exec on [dbo].[cs_Links_Get] TO [Public]
Grant exec on [dbo].[cs_MarkPostAsRead] TO [Public]
Grant exec on [dbo].[cs_MarkThreadAsRead] TO [Public]
Grant exec on [dbo].[cs_Media_Post_Get] TO [Public]
Grant exec on [dbo].[cs_Media_Posts_Get] TO [Public]
Grant exec on [dbo].[cs_Membership_ChangePasswordAnswer] TO [Public]
Grant exec on [dbo].[cs_Membership_GetUsersByName] TO [Public]
Grant exec on [dbo].[cs_Membership_IsUserNameTaken] TO [Public]
Grant exec on [dbo].[cs_Membership_RenameUser] TO [Public]
Grant exec on [dbo].[cs_Membership_ValidatePasswordAnswer] TO [Public]
Grant exec on [dbo].[cs_Message_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Messaging_DeleteActivityMessagesForUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_DeleteProfileAnnouncement] TO [Public]
Grant exec on [dbo].[cs_Messaging_DeleteProfileAnnouncementsForUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_DeleteProfileComment] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetActivityMessage] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetActivityMessagesForHub] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetActivityMessagesForSite] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetActivityMessagesForUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetConversationByConversationId] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetConversationByMessageId] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetConversationIdsForParticipant] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetConversationMessage] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetFriendsActivityMessagesForUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetProfileAnnouncement] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetProfileAnnouncementsForUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetProfileCommentsByUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetProfileCommentsForUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetProfileMessage] TO [Public]
Grant exec on [dbo].[cs_Messaging_GetProfileMessagesForUser] TO [Public]
Grant exec on [dbo].[cs_Messaging_InsertIntoActivityMessages] TO [Public]
Grant exec on [dbo].[cs_Messaging_InsertIntoConversationMessages] TO [Public]
Grant exec on [dbo].[cs_Messaging_InsertIntoConversationParticipants] TO [Public]
Grant exec on [dbo].[cs_Messaging_InsertIntoConversations] TO [Public]
Grant exec on [dbo].[cs_Messaging_InsertIntoMessages] TO [Public]
Grant exec on [dbo].[cs_Messaging_InsertIntoProfileMessages] TO [Public]
Grant exec on [dbo].[cs_Messaging_UpdateConversationParticipants] TO [Public]
Grant exec on [dbo].[cs_Messaging_UpdateConversations] TO [Public]
Grant exec on [dbo].[cs_Messaging_UpdateProfileAnnouncement] TO [Public]
Grant exec on [dbo].[cs_Moderate_ApprovePost] TO [Public]
Grant exec on [dbo].[cs_Moderate_CheckUser] TO [Public]
Grant exec on [dbo].[cs_Moderate_DeletePost] TO [Public]
Grant exec on [dbo].[cs_Moderate_Forum_Roles] TO [Public]
Grant exec on [dbo].[cs_Moderate_Forums] TO [Public]
Grant exec on [dbo].[cs_Moderate_Post_Move] TO [Public]
Grant exec on [dbo].[cs_Moderate_Post_UpdateParent] TO [Public]
Grant exec on [dbo].[cs_Moderate_Thread_Merge] TO [Public]
Grant exec on [dbo].[cs_Moderate_Thread_Split] TO [Public]
Grant exec on [dbo].[cs_ModerationAudit_Message_Get] TO [Public]
Grant exec on [dbo].[cs_ModerationAudit_Summary_Get] TO [Public]
Grant exec on [dbo].[cs_ModerationAudit_User_Get] TO [Public]
Grant exec on [dbo].[cs_ModerationAudit_User_SaveEvent] TO [Public]
Grant exec on [dbo].[cs_nntp_GetArticlesToPost] TO [Public]
Grant exec on [dbo].[cs_nntp_GetForumNewsgroups] TO [Public]
Grant exec on [dbo].[cs_nntp_GetLastArticleId] TO [Public]
Grant exec on [dbo].[cs_nntp_Post_Add] TO [Public]
Grant exec on [dbo].[cs_OpenID_AssociateUser] TO [Public]
Grant exec on [dbo].[cs_OpenID_Exists] TO [Public]
Grant exec on [dbo].[cs_OpenID_GetOpenIDs] TO [Public]
Grant exec on [dbo].[cs_OpenID_GetUserID] TO [Public]
Grant exec on [dbo].[cs_OpenID_UnassociateUser] TO [Public]
Grant exec on [dbo].[cs_Permissions_DeleteByRole] TO [Public]
Grant exec on [dbo].[cs_Points_CalculateForPost_Set] TO [Public]
Grant exec on [dbo].[cs_Points_CalculateForPost] TO [Public]
Grant exec on [dbo].[cs_Points_CalculateForPostAndAuthor] TO [Public]
Grant exec on [dbo].[cs_Points_CalculateForUser_Set] TO [Public]
Grant exec on [dbo].[cs_Points_CalculateForUser] TO [Public]
Grant exec on [dbo].[cs_Post_CreateUpdate] TO [Public]
Grant exec on [dbo].[cs_Post_Delete] TO [Public]
Grant exec on [dbo].[cs_Post_Downloads_Log] TO [Public]
Grant exec on [dbo].[cs_Post_GetAuthorID] TO [Public]
Grant exec on [dbo].[cs_Post_GetPageIndex] TO [Public]
Grant exec on [dbo].[cs_Post_ToggleSettings] TO [Public]
Grant exec on [dbo].[cs_Post_Update] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_Add] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_Delete_ForSection] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_Delete] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_Temp_Create] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_Temp_Expire] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_Temp_Get] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_ToggleTemporary] TO [Public]
Grant exec on [dbo].[cs_PostAttachment_Update] TO [Public]
Grant exec on [dbo].[cs_PostAttachment] TO [Public]
Grant exec on [dbo].[cs_PostCategories_Get_ByName] TO [Public]
Grant exec on [dbo].[cs_PostCategories_Get_WithoutPosts] TO [Public]
Grant exec on [dbo].[cs_PostCategories_Get] TO [Public]
Grant exec on [dbo].[cs_PostCategories_Parents_RebuildIndex] TO [Public]
Grant exec on [dbo].[cs_PostCategory_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_PostMetadata_Get] TO [Public]
Grant exec on [dbo].[cs_PostMetadata_Update] TO [Public]
Grant exec on [dbo].[cs_posts_AddAuditDeletedPostContent] TO [Public]
Grant exec on [dbo].[cs_Posts_GetPostIDByFilter] TO [Public]
Grant exec on [dbo].[cs_Posts_GetPostInCategories] TO [Public]
Grant exec on [dbo].[cs_Posts_GetPostsInNoCategories] TO [Public]
Grant exec on [dbo].[cs_Posts_ReindexByGroup] TO [Public]
Grant exec on [dbo].[cs_Posts_ReindexBySection] TO [Public]
Grant exec on [dbo].[cs_Posts_ReindexByTag] TO [Public]
Grant exec on [dbo].[cs_Posts_ReindexByUser] TO [Public]
Grant exec on [dbo].[cs_Posts_UpdatePostsInCategories] TO [Public]
Grant exec on [dbo].[cs_Posts_Views_Add] TO [Public]
Grant exec on [dbo].[cs_Profile_GetPropertiesForUsers] TO [Public]
Grant exec on [dbo].[cs_Rank_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Ranks_Get] TO [Public]
Grant exec on [dbo].[cs_Rating_Add] TO [Public]
Grant exec on [dbo].[cs_Rating_Get] TO [Public]
Grant exec on [dbo].[cs_Rating_Rate] TO [Public]
Grant exec on [dbo].[cs_Rating_Update] TO [Public]
Grant exec on [dbo].[cs_Ratings_Get] TO [Public]
Grant exec on [dbo].[cs_referrals_Add] TO [Public]
Grant exec on [dbo].[cs_referrals_Get] TO [Public]
Grant exec on [dbo].[cs_RemoveAllPostTracking] TO [Public]
Grant exec on [dbo].[cs_RemoveAllSectionTracking] TO [Public]
Grant exec on [dbo].[cs_Report_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_report_ThreadViewsByDay] TO [Public]
Grant exec on [dbo].[cs_Reports_Get] TO [Public]
Grant exec on [dbo].[cs_ReverseTrackingOption] TO [Public]
Grant exec on [dbo].[cs_Role_Get] TO [Public]
Grant exec on [dbo].[cs_RoleQuota_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_RoleQuotas_Get] TO [Public]
Grant exec on [dbo].[cs_Roles_CreateRole] TO [Public]
Grant exec on [dbo].[cs_Roles_Get] TO [Public]
Grant exec on [dbo].[cs_Roles_GetRoleIdsForUsers] TO [Public]
Grant exec on [dbo].[cs_Roles_UpdateRole] TO [Public]
Grant exec on [dbo].[cs_RollerBlog_AddFeed] TO [Public]
Grant exec on [dbo].[cs_RollerBlog_AddPost] TO [Public]
Grant exec on [dbo].[cs_RollerBlog_DeleteFeed] TO [Public]
Grant exec on [dbo].[cs_RollerBlog_GetFeeds] TO [Public]
Grant exec on [dbo].[cs_RollerBlog_GetPosts] TO [Public]
Grant exec on [dbo].[cs_RollerBlog_UpdateFeed] TO [Public]
Grant exec on [dbo].[cs_RollerBlog_UpdatePost] TO [Public]
Grant exec on [dbo].[cs_Search_Add] TO [Public]
Grant exec on [dbo].[cs_Search_IgnoreWords_CreateDelete] TO [Public]
Grant exec on [dbo].[cs_Search_IgnoreWords] TO [Public]
Grant exec on [dbo].[cs_Search_UpdatePostIndexStatus] TO [Public]
Grant exec on [dbo].[cs_SearchBarrel_Search] TO [Public]
Grant exec on [dbo].[cs_Section_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Section_DiskUsage_Update] TO [Public]
Grant exec on [dbo].[cs_Section_GetRandomSectionID] TO [Public]
Grant exec on [dbo].[cs_Section_GetSectionIDByPostID] TO [Public]
Grant exec on [dbo].[cs_Section_IsPublic_Update] TO [Public]
Grant exec on [dbo].[cs_Section_IsPublic_UpdateAll] TO [Public]
Grant exec on [dbo].[cs_Section_IsPublic_UpdateGroup] TO [Public]
Grant exec on [dbo].[cs_Section_MarkRead] TO [Public]
Grant exec on [dbo].[cs_Section_MoveSection] TO [Public]
Grant exec on [dbo].[cs_Section_Permission_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Section_Permissions_Get] TO [Public]
Grant exec on [dbo].[cs_Section_RssPingback_Update] TO [Public]
Grant exec on [dbo].[cs_SectionMembers_Add] TO [Public]
Grant exec on [dbo].[cs_SectionMembers_Delete] TO [Public]
Grant exec on [dbo].[cs_SectionMembers_Get] TO [Public]
Grant exec on [dbo].[cs_Sections_Get] TO [Public]
Grant exec on [dbo].[cs_Sections_GetRead] TO [Public]
Grant exec on [dbo].[cs_Sections_MoveOrReOrder] TO [Public]
Grant exec on [dbo].[cs_Sections_ResetOrder] TO [Public]
Grant exec on [dbo].[cs_SectionTokens_Add] TO [Public]
Grant exec on [dbo].[cs_SectionTokens_Delete] TO [Public]
Grant exec on [dbo].[cs_SectionTokens_Get] TO [Public]
Grant exec on [dbo].[cs_SectionTokens_Update] TO [Public]
Grant exec on [dbo].[cs_Service_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Services_Get] TO [Public]
Grant exec on [dbo].[cs_SetSectionSubscriptionType] TO [Public]
Grant exec on [dbo].[cs_SettingsIDs_Get] TO [Public]
Grant exec on [dbo].[cs_shared_Threads_GetThreadSet] TO [Public]
Grant exec on [dbo].[cs_Site_GetSiteUrls] TO [Public]
Grant exec on [dbo].[cs_Site_Statistics] TO [Public]
Grant exec on [dbo].[cs_SiteSettings_Get] TO [Public]
Grant exec on [dbo].[cs_SiteSettings_Save] TO [Public]
Grant exec on [dbo].[cs_Smiley_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Smilies_Get] TO [Public]
Grant exec on [dbo].[cs_SpamPostArchive] TO [Public]
Grant exec on [dbo].[cs_SpamPostDelete] TO [Public]
Grant exec on [dbo].[cs_SpamPostRevive] TO [Public]
Grant exec on [dbo].[cs_SpamPostReviveOne] TO [Public]
Grant exec on [dbo].[cs_SpamPosts_Get] TO [Public]
Grant exec on [dbo].[cs_split_varchar] TO [Public]
Grant exec on [dbo].[cs_Style_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_Styles_Get] TO [Public]
Grant exec on [dbo].[cs_SubscribedSection_Confirm] TO [Public]
Grant exec on [dbo].[cs_SubscribedSection_Get] TO [Public]
Grant exec on [dbo].[cs_SubscribeToSection] TO [Public]
Grant exec on [dbo].[cs_System_AddNewUrl] TO [Public]
Grant exec on [dbo].[cs_system_CleanForumsRead] TO [Public]
Grant exec on [dbo].[cs_system_CreateCommunity] TO [Public]
Grant exec on [dbo].[cs_system_dbreindex] TO [Public]
Grant exec on [dbo].[cs_system_DeleteCommunity] TO [Public]
Grant exec on [dbo].[cs_system_DeletePostAndAdoptChildren] TO [Public]
Grant exec on [dbo].[cs_system_DeletePostAndChildren] TO [Public]
Grant exec on [dbo].[cs_system_DuplicatePost] TO [Public]
Grant exec on [dbo].[cs_system_GenerateWeblogYearMonthDayList] TO [Public]
Grant exec on [dbo].[cs_system_ModerationAction_AuditEntry] TO [Public]
Grant exec on [dbo].[cs_system_ResetForumStatistics] TO [Public]
Grant exec on [dbo].[cs_system_ResetThreadStatistics] TO [Public]
Grant exec on [dbo].[cs_system_SampleDownload] TO [Public]
Grant exec on [dbo].[cs_system_SampleForum] TO [Public]
Grant exec on [dbo].[cs_system_SampleGallery] TO [Public]
Grant exec on [dbo].[cs_system_SampleGroups] TO [Public]
Grant exec on [dbo].[cs_system_SampleMediaGallery] TO [Public]
Grant exec on [dbo].[cs_system_SampleWeblog] TO [Public]
Grant exec on [dbo].[cs_system_UpdateForum] TO [Public]
Grant exec on [dbo].[cs_system_UpdateMostActiveUsers] TO [Public]
Grant exec on [dbo].[cs_system_UpdateSite] TO [Public]
Grant exec on [dbo].[cs_system_updatestatistics] TO [Public]
Grant exec on [dbo].[cs_system_UpdateThread] TO [Public]
Grant exec on [dbo].[cs_system_UpdateUserPostCount] TO [Public]
Grant exec on [dbo].[cs_system_UpdateUserPostRank] TO [Public]
Grant exec on [dbo].[cs_system_UserIsOnline] TO [Public]
Grant exec on [dbo].[cs_Tags_Get] TO [Public]
Grant exec on [dbo].[cs_TemporaryUserToken_Create] TO [Public]
Grant exec on [dbo].[cs_TemporaryUserToken_Delete] TO [Public]
Grant exec on [dbo].[cs_TemporaryUserToken_Validate] TO [Public]
Grant exec on [dbo].[cs_TemporaryUserTokens_Expire] TO [Public]
Grant exec on [dbo].[cs_ThemeConfigurationData_Delete] TO [Public]
Grant exec on [dbo].[cs_ThemeConfigurationData_ExpireTemp] TO [Public]
Grant exec on [dbo].[cs_ThemeConfigurationData_Get] TO [Public]
Grant exec on [dbo].[cs_ThemeConfigurationData_Update] TO [Public]
Grant exec on [dbo].[cs_Thread_Daily_Stats_Increment] TO [Public]
Grant exec on [dbo].[cs_Thread_Delete] TO [Public]
Grant exec on [dbo].[cs_thread_IsTracked] TO [Public]
Grant exec on [dbo].[cs_Thread_PrevNext] TO [Public]
Grant exec on [dbo].[cs_Thread_Status_Update] TO [Public]
Grant exec on [dbo].[cs_Threads_GetThreadSet] TO [Public]
Grant exec on [dbo].[cs_UnsubscribeFromSection] TO [Public]
Grant exec on [dbo].[cs_UnsubscribeFromThread] TO [Public]
Grant exec on [dbo].[cs_UrlRedirect_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_UrlRedirects_Get] TO [Public]
Grant exec on [dbo].[cs_Urls_Add] TO [Public]
Grant exec on [dbo].[cs_Urls_RedirectLookup] TO [Public]
Grant exec on [dbo].[cs_User_Anonymous_Count] TO [Public]
Grant exec on [dbo].[cs_User_Anonymous_Update] TO [Public]
Grant exec on [dbo].[cs_User_Avatar_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_User_Avatar] TO [Public]
Grant exec on [dbo].[cs_user_CreateUpdateDelete] TO [Public]
Grant exec on [dbo].[cs_User_Delete] TO [Public]
Grant exec on [dbo].[cs_User_Get] TO [Public]
Grant exec on [dbo].[cs_User_GetByEmail] TO [Public]
Grant exec on [dbo].[cs_User_Rename] TO [Public]
Grant exec on [dbo].[cs_User_ToggleSettings] TO [Public]
Grant exec on [dbo].[cs_UserHasPostsAwaitingModeration] TO [Public]
Grant exec on [dbo].[cs_UserInvitation_Create] TO [Public]
Grant exec on [dbo].[cs_UserInvitation_Delete] TO [Public]
Grant exec on [dbo].[cs_UserInvitation_Get] TO [Public]
Grant exec on [dbo].[cs_UserInvitations_Expire] TO [Public]
Grant exec on [dbo].[cs_UserInvitations_GetBeforeDate] TO [Public]
Grant exec on [dbo].[cs_UserInvitations_GetByUser] TO [Public]
Grant exec on [dbo].[cs_users_count_Get] TO [Public]
Grant exec on [dbo].[cs_users_Get] TO [Public]
Grant exec on [dbo].[cs_Users_GetUserIDByFilter] TO [Public]
Grant exec on [dbo].[cs_users_Online] TO [Public]
Grant exec on [dbo].[cs_Users_WhoDownloadedFile] TO [Public]
Grant exec on [dbo].[cs_Vote_Create] TO [Public]
Grant exec on [dbo].[cs_Vote_GetSummary] TO [Public]
Grant exec on [dbo].[cs_weblog_DeleteStaleSpamComments] TO [Public]
Grant exec on [dbo].[cs_weblog_Post_Create] TO [Public]
Grant exec on [dbo].[cs_weblog_Post_Delete] TO [Public]
Grant exec on [dbo].[cs_weblog_Post_Get] TO [Public]
Grant exec on [dbo].[cs_weblog_Post_Update] TO [Public]
Grant exec on [dbo].[cs_weblog_PostsByMonth] TO [Public]
Grant exec on [dbo].[cs_weblog_PostsByMonthList] TO [Public]
Grant exec on [dbo].[cs_weblog_PostSet] TO [Public]
Grant exec on [dbo].[cs_weblog_TrackedThreadsByUser] TO [Public]
Grant exec on [dbo].[cs_weblog_UpdateContentHistory] TO [Public]
Grant exec on [dbo].[cs_weblog_UpdateWeblogRecentContent_Job] TO [Public]
Grant exec on [dbo].[cs_weblog_Weblogs_Get] TO [Public]
Grant exec on [dbo].[csm_EmailIDs_FindUserEmailID] TO [Public]
Grant exec on [dbo].[csm_EmailIDs_GetUserEmailID] TO [Public]
Grant exec on [dbo].[csm_EmailIDs_UpdateUserEmailID] TO [Public]
Grant exec on [dbo].[csm_MailingList_Permissions_Get] TO [Public]
Grant exec on [dbo].[csm_MailingLists_CreateUpdate] TO [Public]
Grant exec on [dbo].[csm_MailingLists_Get] TO [Public]
Grant exec on [dbo].[csm_MessageID_Add] TO [Public]
Grant exec on [dbo].[csm_MessageID_Check] TO [Public]
Grant exec on [dbo].[csm_Post_FindPostParent] TO [Public]
Grant exec on [dbo].[files_comments_getComments] TO [Public]
Grant exec on [dbo].[files_Downloads_Log] TO [Public]
Grant exec on [dbo].[files_Entries_GetEntries] TO [Public]
Grant exec on [dbo].[files_Entry_Get] TO [Public]
Grant exec on [dbo].[files_Post_GetSortOrder] TO [Public]
Grant exec on [dbo].[files_PostAttachment_Get] TO [Public]
Grant exec on [dbo].[files_users_WhoDownloadedFile] TO [Public]
Grant exec on [dbo].[mg_EmailQueue_Delete] TO [Public]
Grant exec on [dbo].[mg_EmailQueue_Failure] TO [Public]
Grant exec on [dbo].[mg_Emails_Dequeue] TO [Public]
Grant exec on [dbo].[mg_Emails_Enqueue] TO [Public]
Grant exec on [dbo].[spam_GetRecentPostCountFromIP] TO [Public]

Reply

Alex Crome replied on Thu, May 29 2008 2:42 AM

rated by 0 users

 I've checked my CS database and whilst only testing a small sample, I found that the cs_ stored procedures all gave Execute to public, whilst the aspnet_ tables did not, instead giving specific aspnet_ roles the execute privilege.

Reply

davestechshop replied on Thu, May 29 2008 10:44 AM

rated by 0 users

I appreciate your reply. That's helpful to know.

I only found one of my aspnet_  procedures gave execute permissions to the aspnet_ role. All the others were blank. This was true of both my upgraded db and a fresh new CS 2008 install.

I wonder what could be causing this...

Also, how can I resolve it exactly right?

Reply

Alex Crome replied on Thu, May 29 2008 12:29 PM

rated by 0 users

For correctly assigning the permissions on the cs_ sprocs, I would suggest downloading the "web installer" version of CS208, then from the cs_4.0_CreateFullDatabase.sql file in that download execute the part of the script that drops existing cs_ stored procedures and recreates then, and assigns permissions to those scripts. (just be careful not to run the last two lines as those will create a second community in your database).

You can also do that for the sprocs in cs_ASPNET2_Membership_Schema_Update

Reply

davestechshop replied on Fri, May 30 2008 5:56 PM

rated by 0 users

I modified cs_4.0_CreateFullDatabase.sql as you suggested. Can I attach files here?

Here is a link to the file for the time being:

http://davestechshop.net/cs_4.0_DropAndCreateSprocs.sql.txt

If anyone wants to take a look at it to verify I have done it correctly, that would be great. I will wait for some feedback before I try it out.

Reply

davestechshop replied on Wed, Jun 18 2008 10:35 PM

rated by 0 users

I know it is a lot to ask, but it sure would be great if someone would take a look at this... I've been holding off on running this script while waiting (hoping) for some feedback. But I'm also getting a lot of exceptions that seem to be permission-related.