Share via


2.1.2.134 S081, Subtables

V0170:

The specification states the following:

 Subclause 11.3, "<table definition>":
  
 <subtable clause> ::=
 UNDER <supertable clause>
  
 <supertable clause> ::=
 <supertable name>
  
 <supertable name> ::=
 <table name>
  
 ...
  
 Conformance Rules
  
 Without Feature S081, "Subtables", conforming SQL language shall not contain a <subtable clause>.
  
 Subclause 12.2, "<grant privilege statement>":
  
 <grant privilege statement> ::=
 GRANT <privileges> TO <grantee> [ { <comma> <grantee> }... ]
 [ WITH HIERARCHY OPTION ]
 [ WITH GRANT OPTION ]
 [ GRANTED BY <grantor> ]
  
 ...
  
 Conformance Rules
  
 Without Feature S081, "Subtables", conforming SQL language shall not contain a <grant privilege statement> that contains WITH HIERARCHY OPTION.
  
 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
  
 ...
  
 Conformance Rules
  
 Without Feature S081, "Subtables", conforming SQL language shall not contain a <privileges> that contains an <action> that contains UNDER and that contains an <object name> that contains a <table name>.
  
 Subclause 12.7, "<revoke statement>":
  
 <revoke privilege statement> ::=
 REVOKE [ <revoke option extension> ] <privileges>
 FROM <grantee> [ { <comma> <grantee> }... ]
 [ GRANTED BY <grantor> ]
 <drop behavior>
  
 <revoke option extension> ::=
 GRANT OPTION FOR
 | HIERARCHY OPTION FOR
  
 ...
  
 Conformance Rules
  
 Without Feature S081, "Subtables", conforming SQL language shall not contain a <revoke option extension> that contains HIERARCHY OPTION FOR.

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

Transact-SQL does not support this feature.