2.1.1.13 E081-09, USAGE privilege

  • Article

V0013:

The specification states the following:

 Subclause 12.3, "<privileges>":
  
 <privileges> ::=
 <object privileges> ON <object name>
  
 <object name> ::=
 [ TABLE ] <table name>
 DOMAIN <domain name>
 COLLATION <collation name>
 CHARACTER SET <character set name>
 TRANSLATION <transliteration name>
 TYPE <schema-resolved user-defined type name>
 SEQUENCE <sequence generator name>
 <specific routine designator>
  
 <object privileges> ::=
 ALL PRIVILEGES
 | <action> [ { <comma> <action> }... ]
  
 <action> ::=
 SELECT
 | SELECT <left paren> <privilege column list> <right paren>
 | SELECT <left paren> <privilege method list> <right paren>
 | DELETE
 | INSERT [ <left paren> <privilege column list> <right paren> ]
 | UPDATE [ <left paren> <privilege column list> <right paren> ]
 | REFERENCES [ <left paren> <privilege column list> <right paren> ]
 | USAGE
 | TRIGGER
 | UNDER
 | EXECUTE

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature.