database context in which the GRANT statement is executed, unless the grantee is denied VIEW DEFINITION or CONTROL permissions at the schema scope or for an individual entity such as a table. For information about the syntax to use for this permission at this scope, seeGRANT (Transact-SQL)....
默认情况下,将 VIEW ANY DATABASE 权限授予 public 角色。因此,默认情况下,每个连接到 SQL Server 实例的用户都可查看该实例中的所有数据库。若要验证此行为,请运行以下查询: 复制 SELECT l.name as grantee_name, p.state_desc, p.permission_name FROM sys.server_permissions AS p JOIN sys.server_princip...
ViewDefinition 属性 Gets or sets the Boolean property value that specifies whether to include the VIEW DEFINITION permission in the permission set. This permission lets the grantee view the metadata that defines the object. 命名空间: Microsoft.SqlServer.Management.Smo 程序集: Microsoft.SqlServer.Smo(...
Transact-SQL 语法约定 语法 syntaxsql GRANT{ permission [ ,...n ] }ONASSEMBLY::assembly_nameTOdatabase_principal[ ,...n ] [WITHGRANTOPTION] [ASgranting_principal] 参数 permission 指定可对程序集授予的权限。 如下所列。 ON ASSEMBLY ::assembly_name ...
2.2.4.2.2.27 CubePermission 2.2.4.2.2.28 Role 2.2.4.2.2.29 ProactiveCaching 2.2.4.2.2.30 ErrorConfiguration 2.2.4.2.2.31 ImpersonationInfo 2.2.4.3 TraceDefinition Complex Types 2.2.5 Simple Types 2.2.6 Attributes 2.2.7 Groups 2.2.8 Attribute Groups 3 Protocol Details 4 Protocol Examples 5 Security...
SQL GRANTVIEWDEFINITIONONROLE::SammamishParkingTOJinghaoLiuWITHGRANTOPTION; GO C. 将对用户的 IMPERSONATE 权限授予应用程序角色 以下示例将对用户IMPERSONATE的HamithaL权限授予AdventureWorks2022应用程序角色AccountsPayable17。 适用于:SQL Server 2008 (10.0.x) 及更高版本、SQL 数据库。
VIEW DEFINITION CONTROL VIEW DEFINITION Permissions Requires CONTROL permission on the object. If you use the AS clause, the specified principal must own the object on which permissions are being revoked. Examples A. Revoking SELECT permission on a table The following example revokes SELECT permissio...
--https://msdn.microsoft.com/zh-cn/library/ms179853(v=sql.120).aspx --为表添加描述信息 EXECUTEsp_addextendedproperty N'MS_Description','导入员工资料表', N'SCHEMA', N'dbo', N'table', N'StaffList',NULL,NULL EXECsp_updateextendedproperty N'MS_Description','导入员工资料表', N'SCHEMA',...
UPDATE CONTROL CONTROL SERVER VIEW DATABASE STATE CONTROL VIEW SERVER STATE VIEW DEFINITION CONTROL VIEW ANY DEFINITION权限执行此语句的主体(或用 AS 选项指定的主体)必须具有对数据库的 CONTROL 权限,或具有隐含对数据库的 CONTROL 权限的更高权限。若...
Hi, i have the following scenario: i have a work account with office365 license on a work tenant and am able to access it via teams app and via web...