SqlServer2000登陆角色的具体权限

服务器角色描述 sysadmin 在 SQL Server 中进行任何活动。该角色的权限跨越所有其它固定服务器角色。一般sa和Buildin/Administrators都属于该角色。 serveradmin 配置服务器范围的设置。 setupadmin 添加和删除链接服务器，并执行某些系统存储过程（如 sp_serveroption）。 securityadmin 管理服务器登录。 processadmin 管理在 SQL Server 实例中运行的进程。 dbcreator 创建和改变数据库。 diskadmin 管理磁盘文件。 bulkadmin 执行 BULK INSERT 语句。 SysAdmin：Add extended proceduresAdd member to bulkadminAdd member to dbcreatorAdd member to diskadminAdd member to processadminAdd member to securityadminAdd member to serveradminAdd member to setupadminAdd member to sysadminAdd/drop to/from db_accessadminAdd/drop to/from db_backupoperatorAdd/drop to/from db_datareaderAdd/drop to/from db_datawriterAdd/drop to/from db_ddladminAdd/drop to/from db_denydatareaderAdd/drop to/from db_denydatawriterAdd/drop to/from db_ownerAdd/drop to/from db_securityadminAdd/drop/configure linked serversAll DDL but GRANT,REVOKE,DENYALTER DATABASEBACKUP DATABASEBACKUP LOGBULK INSERTCHECKPOINTComplete SETUSER SQL userConstraints on System tablesCREATE DATABASECreate indices on system tablesCreate/delete/modify system tablesdbcc change 'on' rulesdbcc checkallocdbcc checkdbdbcc checkfilegroupdbcc checkidentdbcc checktabledbcc cleantabledbcc dbreindexdbcc dropcleanbuffersdbcc freeproccachedbcc inputbufferdbcc outputbufferdbcc pintabledbcc proccachedbcc setcpuweightdbcc setioweightdbcc show_statisticsdbcc showcontigdbcc showoptweightsDBCC ShrinkDatabasedbcc shrinkfiledbcc traceon/offdbcc updateusageDELETE permission on any objectDENYDISK INITDROP DATABASEEXECUTE any procedureExtend databaseGRANTGrant/deny/revoke CREATE DATABASEINSERT permission on any objectKILLMark a stored procedure as startupRaiserror With LogRead the error logRECONFIGUREREFERENCES permission on any tableRESTORE DATABASERESTORE LOGREVOKESELECT permission on any objectSHUTDOWNsp_addaliassp_addapprolesp_addgroupsp_addlinkedsrvloginsp_addloginsp_addrolesp_addrolemembersp_addumpdevicesp_addusersp_altermessagesp_approlepasswordsp_change_users_loginsp_changedbownersp_changegroupsp_changeobjectownersp_configuresp_dbcmptlevelsp_dboption (update)sp_dboption update partsp_defaultdbsp_defaultlanguagesp_denyloginsp_diskdefaultsp_dropaliassp_dropapprolesp_dropdevicesp_dropgroupsp_droplinkedsrvloginsp_droploginsp_dropremoteloginsp_droprolesp_droprolemembersp_dropusersp_fulltext_catalogsp_fulltext_columnsp_fulltext_databasesp_fulltext_servicesp_fulltext_tablesp_grantdbaccesssp_grantloginsp_helploginssp_passwordsp_recompilesp_refreshviewsp_remoteoptionsp_remoteoption (update)sp_renamesp_renamedbsp_revokedbaccesssp_revokeloginsp_tableoptionsp_updatestatsTRUNCATE TABLEUPDATE permission on any objectUSE to a suspect database?ServerAdminSetUp adminSecurity adminProcess AdminDisk Amindatabase creatorBulkAdminBULK INSERT

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

?