Schema documentation for component revoke_option

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element revoke_option_extension

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Used by

Element

revoke_privilege_statement

Model

grant_option_for | hierarchy_option_for

Children

grant_option_for, hierarchy_option_for

Instance

<revoke_option_extension xmlns="http://www.sqlparser.com/xml/ansi2003">
  <grant_option_for>{1,1}</grant_option_for>
  <hierarchy_option_for>{1,1}</hierarchy_option_for>
</revoke_option_extension>

Source

<xs:element name="revoke_option_extension">
  <xs:complexType>
    <xs:choice>
      <xs:element name="grant_option_for">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_grant"/>
            <xs:element ref="kw_option"/>
            <xs:element ref="kw_for"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="hierarchy_option_for">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_hierarchy"/>
            <xs:element ref="kw_option"/>
            <xs:element ref="kw_for"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element revoke_option_extension / grant_option_for

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

kw_grant , kw_option , kw_for

Children

kw_for, kw_grant, kw_option

Instance

<grant_option_for xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_grant>{1,1}</kw_grant>
  <kw_option>{1,1}</kw_option>
  <kw_for>{1,1}</kw_for>
</grant_option_for>

Source

<xs:element name="grant_option_for">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_grant"/>
      <xs:element ref="kw_option"/>
      <xs:element ref="kw_for"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element revoke_option_extension / hierarchy_option_for

Namespace

http://www.sqlparser.com/xml/ansi2003

Diagram

Properties

content

complex

Model

kw_hierarchy , kw_option , kw_for

Children

kw_for, kw_hierarchy, kw_option

Instance

<hierarchy_option_for xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_hierarchy>{1,1}</kw_hierarchy>
  <kw_option>{1,1}</kw_option>
  <kw_for>{1,1}</kw_for>
</hierarchy_option_for>

Source

<xs:element name="hierarchy_option_for">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_hierarchy"/>
      <xs:element ref="kw_option"/>
      <xs:element ref="kw_for"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>