是被授予权限的语句。语句列表可以包括:CREATEDATABASECREATEDEFAULTCREATEFUNCTIONCREATEPROCEDURECREATERULECREATETABLECREATEVIEWBACKUPDATABASEBACKUPLOG 好像没有指定库的Execute.于是。。。 sql 2005可以实现 晕。。 /* CREATE A NEW ROLE */CREATEROLE db_executor/* GRANT EXECUTE TO THE ROLE */GRANTEXECUTETOdb_e...
TO DATABASE ROLE <database_role_name> [ WITH GRANT OPTION ] Where: globalPrivileges ::= { CREATE { ACCOUNT | COMPUTE POOL | DATA EXCHANGE LISTING | DATABASE | FAILOVER GROUP | INTEGRATION | NETWORK POLICY | EXTERNAL VOLUME | REPLICATION GROUP | ROLE | SHARE | USER | WAREHOUSE } | AP...
Database_role 指定数据库角色。 Application_role 指定应用程序角色。 Database_user_mapped_to_Windows_User 指定映射到 Windows 用户的数据库用户。 Database_user_mapped_to_Windows_Group 指定映射到 Windows 组的数据库用户。 Database_user_mapped_to_certificate ...
GRANT{{CREATE|CONNECT|TEMPORARY|TEMP}[,...]|ALL[PRIVILEGES]}ONDATABASEdatabase_name[,...]TO{[GROUP]role_name|PUBLIC}[,...][WITHGRANTOPTION]; Grant the domain access permission to a specified role or user. GRANT{USAGE|ALL[PRIVILEGES]}ONDOMAINdomain_name[,...]TO{[GROUP]role_name|PUBLI...
Database_user 指定資料庫使用者。Database_role 指定資料庫角色。Application_role 指定應用程式角色。Database_user_mapped_to_Windows_User 指定對應至 Windows 使用者的資料庫使用者。Database_user_mapped_to_Windows_Group 指定對應至 Windows 群組的資料庫使用者。
GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] } ON DATABASE database_name [, ...] TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]; 将域的访问权限赋予指定的用户或角色。 1 2 3 4 GRANT { USAGE | ALL [ PRIVILEGES...
I then created a Database Role, MyDBRole, in Northwind and added several Users to it.I want members of MyDBRole to be able to execute master.dbo.myProcThe only way I can seem to do it is by granting: use master grant execute on myProc to public...
ON DATABASE database_name [, ...] TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]; 4)将函数的访问权限赋予给指定的用户或角色 GRANT { { EXECUTE | ALTER | DROP | COMMENT } [, ...] | ALL [ PRIVILEGES ] } ...
I then created a Database Role, MyDBRole, in Northwind and added several Users to it. I want members of MyDBRole to be able to execute master.dbo.myProc The only way I can seem to do it is by granting: use master grant execute on myProc to public ...
GRANTpermission [ ,...n ]ONSCHEMA::schema_nameTOdatabase_principal[ ,...n ] [WITHGRANTOPTION] [ASgranting_principal] 参数 permission 指定可授予架构的权限。 有关权限的列表,请参阅本主题后面的“备注”部分。 ON SCHEMA :: schema_name