SQL 複製 GRANT UNMASK ON OBJECT::Data.Membership (email) to OutreachCoordinator; GO 相關內容 DENY 物件權限 (Transact-SQL) REVOKE 物件權限 (Transact-SQL) 物件目錄檢視 (Transact-SQL) 權限(資料庫引擎) 主體(資料庫引擎) 安全性實體 sys.fn_builtin_permissions (Transact-SQL) HAS_P...
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 技能节挑战 ...
Chart of SQL Server permissionsFor a poster sized chart of all Database Engine permissions in PDF format, see https://aka.ms/sql-permissions-poster.PermissionsThe grantor (or the principal specified with the AS option) must have either the permission itself with GRANT OPTION, or a higher ...
SQL_Server_login_mapped_to_asymmetric_key 指定映射到非对称密钥的 SQL Server 登录名。server_role 指定用户定义的服务器角色。备注只有在当前数据库为 master 时,才可授予其服务器作用域内的权限。可以在 sys.server_permissions 目录视图中查看有关服务器权限的信息;在 sys.server_principals 目录视图中查看有...
授予对服务器的权限。 Transact-SQL 语法约定语法 复制 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_...
GRANT { EXECUTE | ALL [ PRIVILEGES ] } ON { FUNCTION {function_name ( [ {[ argmode ] [ arg_name ] arg_type} [, ...] ] )} [, ...] | ALL FUNCTIONS IN SCHEMA schema_name [, ...] } TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]; 将过程语...
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 ...
GRANT (Transact-SQL) 权限(数据库引擎) 主体(数据库引擎) CREATE CERTIFICATE (Transact-SQL) CREATE ASYMMETRIC KEY (Transact-SQL) CREATE APPLICATION ROLE (Transact-SQL) 加密层次结构 sys.fn_builtin_permissions (Transact-SQL) sys.fn_my_permissions (Transact-SQL) ...
Grants permissions on a database user, database role, or application role in SQL Server. Transact-SQL syntax conventions Syntax syntaxsql Copy GRANT permission [ ,...n ] ON { [ USER :: database_user ] | [ ROLE :: database_role ] | [ APPLICATION ROLE :: application_role ] } TO...
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 is a problem in the Microsoft products that are listed in the "Applies to"...