若要檢視 SQL Server 2014 (12.x) 和舊版的 Transact-SQL 語法,請參閱 舊版檔。引數permission指定可授與的結構描述所含物件之權限。 如需許可權清單,請參閱。ALL授與ALL 不會授與所有可能的權限。 授與 ALL 相當於授與適用於指定之物件的所有 ANSI-92 權限。 ALL 有多種意義,如下所示:純量函式權限
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric Grants permissions on a securable to a principal. The general concept is to GRANT <some permission> ON...
REVOKE (オブジェクトの権限の取り消し) (Transact-SQL) オブジェクト カタログ ビュー (Transact-SQL) 権限(データベース エンジン) プリンシパル (データベース エンジン) セキュリティ保護可能 sys.fn_builtin_permissions (Transact-SQL) HAS_PERMS_BY_NAME (Transact-SQL) sys.fn_my_per...
sql Server Azure SQL 資料庫 Azure SQL 受控執行個體 Azure Synapse Analytics Platform System (PDW) SQL 分析端點在 Microsoft Fabric SQL 資料庫中的 Microsoft 網 狀架構倉儲中Microsoft網狀架構 授與資料表、檢視表、資料表值函式、預存程序、擴充預存程序、純量函數、彙總函式、服務佇列或同義字的權限。
适用于: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_Server_logi...
GRANT (Transact-SQL) HAS_PERMS_BY_NAME (Transact-SQL) 权限(数据库引擎) 主体(数据库引擎) sys.fn_builtin_permissions (Transact-SQL) sys.fulltext_catalogs (Transact-SQL) sys.fulltext_stoplists (Transact-SQL) 其他资源 活动 加入AI 技能节挑战 ...
SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Grants permissions on a securable to a principal. The general concept is toGRANT ...
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...
we will discuss how SQL server takes server memory and number of concurrent queries into considerations. The server needs to consider such dynamic factors to avoid committing memory beyond its physical limit. This is done in 2 distinct steps. First, the server calculates how much memory to grant...
Note In SQL Server 2014 SP2, the MemoryFractions showplan XML attribute is updated for the optimized nested loop join operator to reflect the memory that's required to run it. Status Microsoft has confirmed that this i...