授與對 SQL Server 中憑證的權限。 Transact-SQL 語法慣例 注意 Azure Synapse Analytics 的無伺服器 SQL 集區不支援此語法。 語法 syntaxsql 複製 GRANT permission [ ,...n ] ON CERTIFICATE :: certificate_name TO principal [ ,...n ] [ WITH GRANT OPTION ] [ AS granting_principal ] 引數 pe...
Syntax för SQL Server, Azure SQL Database och Fabric SQL Database. syntaxsql Kopiera -- Simplified syntax for GRANT GRANT { ALL [ PRIVILEGES ] } | permission [ ( column [ , ...n ] ) ] [ , ...n ] [ ON [ class :: ] securable ] TO principal [ , ...n ] [ WITH GRANT...
syntaxsql コピー GRANT permission [ ,...n ] ON SEARCH PROPERTY LIST :: search_property_list_name TO database_principal [ ,...n ] [ WITH GRANT OPTION ] [ AS granting_principal ] 注意 SQL Server 2014 (12.x) 以前のバージョンの Transact-SQL 構文を確認するには、以前のバ...
syntaxsql 複製 GRANT permission [ ,...n ] TO <grantee_principal> [ ,...n ] [ WITH GRANT OPTION ] [ AS <grantor_principal> ] <grantee_principal> ::= SQL_Server_login | SQL_Server_login_mapped_to_Windows_login | SQL_Server_login_mapped_to_Windows_group | SQL_Server_login_mapped...
适用于:SQL Server Azure SQL 数据库 Azure SQL 托管实例 Azure Synapse Analytics Microsoft Fabric SQL 数据库 授予对非对称密钥的权限。 Transact-SQL 语法约定 备注 Azure Synapse Analytics 中的无服务器 SQL 池不支持此语法。 语法 syntaxsql 复制 GRANT { permission [ ,...n ] } ON ASYMMETRIC KEY :...
SQL Server Azure SQL 数据库 Azure SQL 托管实例 Azure Synapse Analytics Analytics Platform System (PDW) Microsoft Fabric 中的 SQL 终结点 Microsoft Fabric 中的仓库 Microsoft Fabric SQL 数据库 授予对架构的权限。 Transact-SQL 语法约定 语法 syntaxsql ...
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 语法约定 语法 syntaxsql 复制 sp_grant_proxy_to_subsystem [ [ @proxy_id = ] proxy_id ] [ , [ @proxy_name = ] N'proxy_name' ] [ , [ @subsystem_id = ] subsystem_id ] [ , [ @subsystem_name = ] N'subsystem_name' ] [ ; ] 参数 [ @proxy_id = ] proxy_id...
to your MySQL server version for the right syntax to use near '这里是用户输入的SQL语句出错点...
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'identified by '123456'' at line 1 这是因为在MySQL8版本之前,使用GRANT语句通常可以同时创建用户并授予其权限。然而,在MySQL8版本中,引入了...