LSX-blog

Feed Rss

【收录】MSSQL 服务器角色介绍

12.11.2011, MSSQL, by .

固定服务器角色
sysadmin 可以在 SQL Server 中执行任何活动。
serveradmin 可以设置服务器范围的配置选项,关闭服务器。
setupadmin 可以管理链接服务器和启动过程。
securityadmin 可以管理登录和 CREATE DATABASE 权限,还可以读取错误日志和更改密码。
processadmin 可以管理在 SQL Server 中运行的进程。
dbcreator 可以创建、更改和除去数据库。
diskadmin 可以管理磁盘文件。
bulkadmin 可以执行 BULK INSERT 语句。


固定数据库角色
db_owner 执行数据库中的所有维护和配置活动。
db_accessadmin 添加或删除 Windows 用户、组和 SQL Server 登录的访问权限。
db_datareader 读取所有用户表中的所有数据。
db_datawriter 添加、删除或更改所有用户表中的数据。
db_ddladmin 在数据库中运行任何数据定义语言 (DDL) 命令。
db_securityadmin 修改角色成员身份并管理权限。
db_backupoperator 备份数据库。
db_denydatareader 无法读取数据库用户表中的任何数据。
db_denydatawriter 无法添加、修改或删除任何用户表或视图中的数据。

【收录】MSSQL 服务器角色介绍 有 506 条回应

  1. I’ve been browsing on-line greater than 3 hours these days,
    yet I by no means found any fascinating article like
    yours. It’s lovely value sufficient for me. In my opinion, if
    all site owners and bloggers made excellent content material as you did, the internet will
    probably be much more useful than ever before.

    回复
  2. Right here is the right blog for everyone who wants to find out about this topic. You realize so much its almost hard to argue with you (not that I really would want to…HaHa). You certainly put a fresh spin on a topic that has been written about for years. Great stuff, just great!

    回复
  3. When I originally commented I clicked the “Notify me when new comments are added” checkbox and now each time a
    comment is added I get several emails with the same comment.
    Is there any way you can remove people from that service?
    Thanks!

    回复
  4. Thanks for sharing your thoughts about mssql. Regards

    回复
  5. Hi it’s me, I am also visiting this web page regularly,
    this web site is really nice and the viewers are actually sharing nice thoughts.

    回复
  6. Hi mates, how is all, and what you desire to say about this post, in my view its genuinely
    amazing for me.

    回复

watch porn进行回复 取消回复

电子邮件地址不会被公开。 必填项已用*标注