dboUser Properties
| Name | Value |
|---|---|
| Name | dbo |
| Login | DGC\JamesC |
| Roles | public, db_owner |
Objects
| Name | Type |
|---|---|
| AnonymousUsers | Table |
| Emails | Table |
| ForumGroups | Table |
| Forums | Table |
| forums_AddForum | StoredProcedure |
| forums_AddForumGroup | StoredProcedure |
| forums_AddForumToRole | StoredProcedure |
| forums_AddModeratedForumForUser | StoredProcedure |
| forums_AddPost | StoredProcedure |
| forums_AddUserToRole | StoredProcedure |
| forums_ApproveModeratedPost | StoredProcedure |
| forums_ApprovePost | StoredProcedure |
| forums_CanModerate | StoredProcedure |
| forums_CanModerateForum | StoredProcedure |
| forums_ChangeForumGroupSortOrder | StoredProcedure |
| forums_ChangeUserPassword | StoredProcedure |
| forums_CheckUserCredentials | StoredProcedure |
| forums_CreateNewRole | StoredProcedure |
| forums_CreateNewUser | StoredProcedure |
| forums_DeleteForum | StoredProcedure |
| forums_DeleteModeratedPost | StoredProcedure |
| forums_DeletePost | StoredProcedure |
| forums_DeletePostAndChildren | StoredProcedure |
| forums_DeleteRole | StoredProcedure |
| forums_FindUsersByName | StoredProcedure |
| forums_Forum | View |
| forums_GetAllButOneForum | StoredProcedure |
| forums_GetAllForumGroups | StoredProcedure |
| forums_GetAllForumGroupsForModeration | StoredProcedure |
| forums_GetAllForums | StoredProcedure |
| forums_GetAllForumsByForumGroupId | StoredProcedure |
| forums_GetAllMessages | StoredProcedure |
| forums_GetAllRoles | StoredProcedure |
| forums_GetAllTopicsPaged | StoredProcedure |
| forums_GetAllUnmoderatedTopicsPaged | StoredProcedure |
| forums_GetAllUsers | StoredProcedure |
| forums_GetAnonymousUsersOnline | StoredProcedure |
| forums_GetBannedUsers | StoredProcedure |
| forums_GetEmailInfo | StoredProcedure |
| forums_GetEmailList | StoredProcedure |
| forums_GetForumByPostID | StoredProcedure |
| forums_GetForumByThreadID | StoredProcedure |
| forums_GetForumGroupByForumID | StoredProcedure |
| forums_GetForumGroupNameByID | StoredProcedure |
| forums_GetForumInfo | StoredProcedure |
| forums_GetForumMessageTemplateList | StoredProcedure |
| forums_GetForumModerators | StoredProcedure |
| forums_GetForumsByForumGroupId | StoredProcedure |
| forums_GetForumsForModerationByForumGroupId | StoredProcedure |
| forums_GetForumsModeratedByUser | StoredProcedure |
| forums_GetForumsNotModeratedByUser | StoredProcedure |
| forums_GetForumViewByUsername | StoredProcedure |
| forums_GetMessage | StoredProcedure |
| forums_GetModeratedForums | StoredProcedure |
| forums_GetModeratedPosts | StoredProcedure |
| forums_GetModeratorsForEmailNotification | StoredProcedure |
| forums_GetNextPostID | StoredProcedure |
| forums_GetNextThreadID | StoredProcedure |
| forums_GetParentID | StoredProcedure |
| forums_GetPostInfo | StoredProcedure |
| forums_GetPostRead | StoredProcedure |
| forums_GetPrevNextThreadID | StoredProcedure |
| forums_GetPrevPostID | StoredProcedure |
| forums_GetPrevThreadID | StoredProcedure |
| forums_GetRoleDescription | StoredProcedure |
| forums_GetRolesByForum | StoredProcedure |
| forums_GetRolesByUser | StoredProcedure |
| forums_GetSearchResults | StoredProcedure |
| forums_GetSearchResultsByText | StoredProcedure |
| forums_GetSearchResultsByText_FTQ | StoredProcedure |
| forums_GetSearchResultsByUser | StoredProcedure |
| forums_GetSingleMessage | StoredProcedure |
| forums_GetStatistics | StoredProcedure |
| forums_GetSummaryInfo | StoredProcedure |
| forums_GetThread | StoredProcedure |
| forums_GetThreadByParentID | StoredProcedure |
| forums_GetThreadByPostID | StoredProcedure |
| forums_GetThreadByPostIDPaged | StoredProcedure |
| forums_GetThreadByPostIDPaged_BackUp | StoredProcedure |
| forums_GetThreadByPostIDPaged2 | StoredProcedure |
| forums_GetTimezoneByUsername | StoredProcedure |
| forums_GetTop25NewPosts | StoredProcedure |
| forums_GetTopicsUserIsTracking | StoredProcedure |
| forums_GetTopicsUserMostRecentlyParticipatedIn | StoredProcedure |
| forums_GetTotalNumberOfForums | StoredProcedure |
| forums_GetTotalPostCount | StoredProcedure |
| forums_GetTotalPostsForThread | StoredProcedure |
| forums_GetTotalUsers | StoredProcedure |
| forums_GetTrackingEmailsForThread | StoredProcedure |
| forums_GetUnmoderatedPostStatus | StoredProcedure |
| forums_GetUserGroups | StoredProcedure |
| forums_GetUserInfo | StoredProcedure |
| forums_GetUsernameByEmail | StoredProcedure |
| forums_GetUserNameFromPostID | StoredProcedure |
| forums_GetUsersByFirstCharacter | StoredProcedure |
| forums_GetUsersOnline | StoredProcedure |
| forums_GetVoteResults | StoredProcedure |
| forums_IsDuplicatePost | StoredProcedure |
| forums_IsUserTrackingPost | StoredProcedure |
| forums_MarkAllThreadsRead | StoredProcedure |
| forums_MarkPostAsRead | StoredProcedure |
| forums_MovePost | StoredProcedure |
| forums_Post | View |
| forums_RemoveForumFromRole | StoredProcedure |
| forums_RemoveModeratedForumForUser | StoredProcedure |
| forums_RemoveUserFromRole | StoredProcedure |
| forums_ReverseTrackingOption | StoredProcedure |
| forums_ToggleOptions | StoredProcedure |
| forums_TopicCountForForum | StoredProcedure |
| forums_TrackAnonymousUsers | StoredProcedure |
| forums_UnbanUser | StoredProcedure |
| forums_UpdateEmailTemplate | StoredProcedure |
| forums_UpdateForum | StoredProcedure |
| forums_UpdateForumGroup | StoredProcedure |
| forums_UpdateMessageTemplateList | StoredProcedure |
| forums_UpdatePost | StoredProcedure |
| forums_UpdateRoleDescription | StoredProcedure |
| forums_UpdateUserFromAdminPage | StoredProcedure |
| forums_UpdateUserInfo | StoredProcedure |
| forums_User | View |
| forums_UserHasPostsAwaitingModeration | StoredProcedure |
| forums_Vote | StoredProcedure |
| ForumsRead | Table |
| HasReadPost | UserDefinedFunction |
| Maintenance_CleanForumsRead | StoredProcedure |
| Maintenance_ResetForumGroupsForInsert | StoredProcedure |
| Messages | Table |
| Moderate_GetPostHistory | StoredProcedure |
| ModerationAction | Table |
| ModerationAudit | Table |
| Moderators | Table |
| Post_Archive | Table |
| Posts | Table |
| PostsRead | Table |
| PrivateForums | Table |
| Reports_UserVisitsByDay | StoredProcedure |
| Search_ForUser | StoredProcedure |
| Statistics_GetModerationActions | StoredProcedure |
| Statistics_GetMostActiveModerators | StoredProcedure |
| Statistics_GetMostActiveUsers | StoredProcedure |
| Statistics_ResetForumStatistics | StoredProcedure |
| Statistics_ResetTopPosters | StoredProcedure |
| Statistics_UpdateForumStatistics | StoredProcedure |
| ThreadTrackings | Table |
| UserRoles | Table |
| Users | Table |
| UsersInRoles | Table |
| Vote | Table |
Permissions
No direct permissions defined (N.B. Permissions may be inherited from roles
SQL
if not exists (select * from dbo.sysusers where name = N'dbo' and uid < 16382) EXEC sp_grantdbaccess N'DGC\JamesC', N'dbo' GO