“授予所有角色"在 SQL Server 中

问题描述

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

Please can someone explain what the following statement does in SQL Server 2005:

GRANT ALL TO pax_writer

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

pax_writer is a database role previously created using the statement

CREATE ROLE pax_writer AUTHORIZATION dbo

推荐答案

授予数据库权限

这是您唯一一次可以将 ON ThingsAndStuff 子句排除在外的情况.

This is the only time you can leave the ON ThingsAndStuff clause out.

全部

此选项不会授予所有可能的权限.授予 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.