User Icon dbo

User 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


					

Generated on 26/08/2004 15:05:35 by DataAide.