sql-server - SQL Server 中的 "GRANT ALL TO role"

Question

请有人解释一下以下语句在 SQL Server 2005 中的作用:

GRANT ALL TO pax_writer

pax_writer是之前使用语句创建的数据库角色

CREATE ROLE pax_writer AUTHORIZATION dbo

Answer 1

Grants database permissions

这是唯一一次可以省略 ON ThingsAndStuff 子句。

ALL

This option does not grant all possible permissions. Granting ALL is equivalent to granting the following permissions: BACKUP DATABASE, BACKUP LOG, CREATE DATABASE, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, and CREATE VIEW.