授予对 SQL Server 中的数据库的权限。 Transact-SQL 语法约定 语法 syntaxsql复制 GRANT<permission>[ ,...n ]TO<database_principal>[ ,...n ] [WITHGRANTOPTION] [AS<database_principal>]<permission>::=permission |ALL[PRIVILEGES]<database_principal>::=Database_user|Database_role|Application_role...
SQL 分析端點在 Microsoft Fabric SQL 資料庫中的 Microsoft 網 狀架構倉儲中Microsoft網狀架構 授與SQL Server 中資料庫使用者、資料庫角色或應用程式角色的權限。 Transact-SQL 語法慣例 語法 syntaxsql GRANTpermission [ ,...n ]ON{ [USER::database_user] | [ROLE::database_role] | [APPLICATIONRO...
适用于:SQL ServerAzure SQL 托管实例 授予服务器的权限。 Transact-SQL 语法约定 语法 syntaxsql复制 GRANTpermission [ ,...n ]TO<grantee_principal>[ ,...n ] [WITHGRANTOPTION] [AS<grantor_principal>]<grantee_principal>::=SQL_Server_login|SQL_Server_login_mapped_to_Windows_login|SQL...
适用于:SQL ServerAzure SQL 数据库Azure SQL 托管实例Azure Synapse AnalyticsAnalytics Platform System (PDW)Microsoft Fabric SQL 数据库 授予搜索属性列表的权限。 Transact-SQL 语法约定 语法 syntaxsql GRANTpermission [ ,...n ]ONSEARCHPROPERTYLIST::search_property_list_nameTOdatabase_principal[ ,...n ...
Transact-SQL 語法慣例 語法 syntaxsql GRANT<permission>[ ,...n ]ON[OBJECT:: ][schema_name].object_name[ (column_name[ ,...n ] ) ]TO<database_principal>[ ,...n ] [WITHGRANTOPTION] [AS<database_principal>]<permission>::=ALL[PRIVILEGES] | permission [ (column_name[ ,...n ] )...
Learn how to grant permissions on a stored procedure in SQL Server by using SQL Server Management Studio or Transact-SQL.
Grants permissions on a database in SQL Server. Transact-SQL syntax conventions Syntax syntaxsqlCopy GRANT<permission>[ ,...n ]TO<database_principal>[ ,...n ] [WITHGRANTOPTION] [AS<database_principal>]<permission>::=permission |ALL[PRIVILEGES]<database_principal>::=Database_user|Database...
Transact-SQL 语法约定 语法 GRANT permission [ ,...n ] ON SCHEMA :: schema_name TO database_principal [ ,...n ] [ WITH GRANT OPTION ] [ AS granting_principal ] 参数 permission 指定可授予架构的权限。有关权限的列表,请参阅本主题后面的“备注”部分。
This article describes how to grant the View Server State permission in Microsoft Forecaster when you are using Microsoft SQL Server 2005. More Information All administrator-level users must have the View Server State permission before you create new periods or before you validate databases in Microso...
This article describes how to grant the View Server State permission in Microsoft Forecaster when you are using Microsoft SQL Server 2005. More Information All administrator-level users must have the View Server State permission before you create new periods or befo...