問題描述
請有人解釋以下語句在 SQL Server 2005 中的作用:
Please can someone explain what the following statement does in SQL Server 2005:
GRANT ALL TO pax_writer
pax_writer 是之前使用語句創(chuàng)建的數(shù)據(jù)庫角色
pax_writer is a database role previously created using the statement
CREATE ROLE pax_writer AUTHORIZATION dbo
推薦答案
授予數(shù)據(jù)庫權(quán)限
這是您唯一一次可以將 ON ThingsAndStuff 子句排除在外的情況.
This is the only time you can leave the ON ThingsAndStuff clause out.
全部
此選項不會授予所有可能的權(quán)限.授予 ALL 是相當(dāng)于授予以下權(quán)限:備份數(shù)據(jù)庫，備份記錄，創(chuàng)建數(shù)據(jù)庫，創(chuàng)建默認值，創(chuàng)建函數(shù)，創(chuàng)建程序，創(chuàng)建規(guī)則、創(chuàng)建表和創(chuàng)建查看.
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.
這篇關(guān)于“授予所有角色"在 SQL Server 中的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！