mssql 用户角色分析
转载自:https://www.cnblogs.com/liunatural/archive/2009/08/20/1550852.html
- bulkadmin
运行大量的insert 语句
- dbcreator
The members of dbcreator server role can create, alter, and resize databases.(创建、修改和重置数据库)
- diskadmin
The members of diskadmin server role can manage disk files.(管理磁盘上的文件)
- processadmin
The members of processadmin server role can manage the processes running in SQL Server.(管理服务器上进程)
public
- securityadmin
The members of securityadmin server role can create and manage server logins and auditing, and read error logs.(创建和管理服务气的登录和编辑,读取错误日志)
- serveradmin
The members of serveradmin server role can change server configuration parameters and shut down the server.(可以修改服务器的配置参数和关闭服务器)
- setupadmin
The members of setupadmin server role can manage linked servers (add or remove linked servers), manage replication, manage extended stored procedures, and execute some system stored procedures, such as sp_serveroption.(可以管理【添加或删除】链接用户,执行一部分系统的存储过程)
- sysadmin
The members of sysadmin server role can perform any activity in SQL Server and have completes control over all database functions. (可以控制服务器上的任何活动,以及全部的数据库的完整控制)