数据库角色管理，已经可以使用alter role，create role和drop role。
2012增加了几个ddl语句，可以操作服务级别的角色管理，
CREATE SERVER ROLE
用来创建服务级别的role。
CREATE
SERVER
ROLE
DBA
SELECT
name
,
type_desc
FROM
sys
.
server_principals
WHERE
type
=
'R'
AND
name
=
'DBA'
name
type_desc
-------------------------------------- ------------------------------------------------------------
DBA SERVER_ROLE
ALTER SERVER ROLE
用来修改服务级别的角色
ALTER
SERVER
ROLE
DBA
ADD
MEMBER fanr
SELECT
b
.
name
,
c
.
name
FROM
sys
.
server_role_members
a
INNER
JOIN
sys
.
server_principals
b
ON
a
.
role_principal_id
=
b
.
principal_id
INNER
JOIN
sys
.
server_principals
c
ON
a
.
member_principal_id
=
c
.
principal_id
WHERE
b
.
name
=
'DBA'
name name
---------------------------------------
DBA fanr
ALTER
SERVER
ROLE
dba
DROP
MEMBER fanr
SELECT
b
.
name
,
c
.
name
FROM
sys
.
server_role_members
a
INNER
JOIN
sys
.
server_principals
b
ON
a
.
role_principal_id
=
b
.
principal_id
INNER
JOIN
sys
.
server_principals
c
ON
a
.
member_principal_id
=
c
.
principal_id
WHERE
b
.
name
=
'DBA'
name name
-------------------------- ---------------------
(
0
row
(
s
)
affected
)
DROP SERVER ROLE
删除服务级别角色
DROP
SERVER
ROLE
dba
本文转自 Fanr_Zh 博客园博客，原文链接：http://www.cnblogs.com/Amaranthus/p/5753686.html
，如需转载请自行联系原作者
