GRANTpermission [ ,...n ]ONSCHEMA::schema_nameTOdatabase_principal[ ,...n ] [WITHGRANTOPTION] [ASgranting_principal] 参数 permission 指定可授予架构的权限。 有关权限的列表,请参阅本主题后面的“备注”部分。 ON SCHEMA :: schema_name
适用范围:SQL Server(SQL Server 2008 到当前版本)。Transact-SQL 语法约定语法复制 GRANT permission [ ,...n ] ON SCHEMA :: schema_name TO database_principal [ ,...n ] [ WITH GRANT OPTION ] [ AS granting_principal ] 参数permission 指定可授予架构的权限。 有关权限的列表,请参阅本主题后面...
对于GRANT语句的理解就像造句一样 GRANT 某种权限 ON 安全对象类型::安全对象 TO 主体。如果指定了WITH GRANT OPTION,则被授予权限的主体可以授予别的主体同样的权限。 对于DENY语句在MSDN中的原型和GRANT大同小异: DENY{ALL[PRIVILEGES] } | permission [ (column[ ,...n ] ) ] [ ,...n ] [ON[ class ...
Applies to: SQL Server Azure SQL Database Azure SQL Managed InstanceYou can grant permissions to create an XML schema collection and also grant permissions on an XML schema collection object.Grant permission to create an XML schema collectionTo create an XML schema collection, the following...
REVOKE[GRANTOPTIONFOR] { [ALL[PRIVILEGES] ] | permission [ (column[ ,...n ] ) ] [ ,...n ] } [ON[ class :: ] securable ] {TO|FROM} principal [ ,...n ] [CASCADE] [ASprincipal ] 一个进行权限控制的例子如下: grantselect--权限ONSchema::SalesLT--类型::安全对象tocareyson--主...
Applies to: SQL Server Azure SQL Database Azure SQL Managed InstanceYou can grant permissions to create an XML schema collection and also grant permissions on an XML schema collection object.Grant permission to create an XML schema collectionTo create an XML schema collection, the following...
isnull(b.permission_name,'Fixed Server-Level Role: '+role_principal_name) as permission_name, isnull(b.state_desc,'GRANT') as state_desc from #tmp_svr_role a left join sys.database_permissions b on a.role_principal_id = b.grantee_principal_id ...
grant create any database, view any database to [pc0627jvc\wcc] --拒绝关闭服务器权限 deny shutdown to [pc0627jvc\wcc] --2.查询服务器权限 select p.name, --授权者 s.name, --被授权者 sp.class_desc, sp.permission_name, sp.state_desc ...
适用范围:SQL Server授予对 XML 架构集合的权限。Transact-SQL 语法约定语法syntaxsql 复制 GRANT permission [ ,...n ] ON XML SCHEMA COLLECTION :: [ schema_name . ] XML_schema_collection_name TO <database_principal> [ ,...n ] [ WITH GRANT OPTION ] [ AS <database_principal> ] <databas...
GRANT permission [ ,...n ] ON SCHEMA :: schema_name TO database_principal [ ,...n ] [ WITH GRANT OPTION ] [ AS granting_principal ] 参数 permission 指定可授予架构的权限。有关权限的列表,请参阅本主题后面的“备注”部分。 ON SCHEMA :: schema_name 指定将对其授予权限的架构。需要范围限...