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 服务器角色介绍 有 412 条回应

  1. It’s apporopriate time too mmake a few planms for thhe
    lolng rrun aand iit iis tkme to be happy. I have learn tthis submit aand
    iff I ciuld I deesire tto recommed you some attention-grabbing things
    orr advice. Maybe you ckuld wite subseequent artijcles regarding thiss article.
    I wosh to leearn moree isshes abvout it!

    回复
  2. It is the best time to make some plans for the future and it’s time to be happy.
    I have read this post and if I could I wish to suggest you some interesting things or suggestions.
    Maybe you could write next articles referring to this article.
    I desire to read more things about it!

    回复
  3. Ahaa, its nice discussion concerning this piece of writing at
    this place at this blog, I have read all that, so now me also commenting here.

    回复
  4. Pretty great post. I just stumbled upon your blog and wanted
    to mention that I have really enjoyed surfing around your blog posts.

    In any case I’ll be subscribing on your feed and I’m hoping you write again soon!

    回复
  5. Hello there! This article couldn’t be written much better!
    Going through this article reminds me of my previous roommate!
    He always kept preaching about this. I’ll send this information to him.
    Pretty sure he’s going to have a great read. Thanks for sharing!

    回复
  6. Greetings from California! I’m bored to death at work so I decided to check
    out your website on my iphone during lunch break.
    I really like the knowledge you provide here and can’t wait to take a
    look when I get home. I’m shocked at how quick
    your blog loaded on my mobile .. I’m not even using WIFI, just 3G ..
    Anyways, great site!

    回复
  7. Ahaa, its nice dialogue concerning this post at this place at this blog, I have read all that, so now me also commenting at this place.

    回复
  8. Ahaa, its pleasant discussion regarding this post
    at this place at this web site, I have read all that, so now me also commenting here.

    回复
  9. I’ve been browsing online more than 2 hours today, yet I never found any interesting article like yours.
    It’s pretty worth enough for me. In my view, if all site owners and bloggers made
    good content as you did, the net will be a lot more useful
    than ever before.

    回复
  10. Ahaa, its fastidious conversation on the
    topic of this piece of writing at this place at this web site, I have read all that,
    so now me also commenting at this place.

    回复
  11. If some one wants to be updated with most up-to-date technologies afterward he must be visit this website and be up to date all
    the time.

    回复
  12. Hello there! This post could not be written much better!
    Reading through this article reminds me of my previous
    roommate! He always kept talking about this. I am going to send this information to him.
    Fairly certain he’s going to have a very good read.
    I appreciate you for sharing!

    回复

发表评论

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