2.1.1.12 E081, Basic Privileges

  • Article

V0012:

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 partially supports this feature. Transact-SQL supports all of feature E081's subfeatures except E081-09 (section 2.1.1.13).