Schema documentation for component grant_privilege

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element grant_privilege_statement

Namespace

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

Diagram

Properties

content

complex

Used by

Element	grant_statement
Element Group	access_control

Model

kw_grant | privileges | kw_to | grantee+ | with_hierarchy_option{0,1} | with_grant_option{0,1} | granted_by_grantor{0,1}

Children

granted_by_grantor, grantee, kw_grant, kw_to, privileges, with_grant_option, with_hierarchy_option

Instance

<grant_privilege_statement xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_grant>{1,1}</kw_grant>
  <privileges>{1,1}</privileges>
  <kw_to>{1,1}</kw_to>
  <grantee>{1,unbounded}</grantee>
  <with_hierarchy_option>{0,1}</with_hierarchy_option>
  <with_grant_option>{0,1}</with_grant_option>
  <granted_by_grantor>{0,1}</granted_by_grantor>
</grant_privilege_statement>

Source

<xs:element name="grant_privilege_statement">
  <xs:complexType>
    <xs:choice>
      <xs:element ref="kw_grant"/>
      <xs:element ref="privileges"/>
      <xs:element ref="kw_to"/>
      <xs:element ref="grantee" maxOccurs="unbounded"/>
      <xs:element name="with_hierarchy_option" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_with"/>
            <xs:element ref="kw_hierarchy"/>
            <xs:element ref="kw_option"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element name="with_grant_option" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_with"/>
            <xs:element ref="kw_grant"/>
            <xs:element ref="kw_option"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element ref="granted_by_grantor" minOccurs="0"/>
    </xs:choice>
  </xs:complexType>
</xs:element>

Element grant_privilege_statement / with_hierarchy_option

Namespace

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

Diagram

Properties

content	complex
minOccurs	0

Model

kw_with , kw_hierarchy , kw_option

Children

kw_hierarchy, kw_option, kw_with

Instance

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

Source

<xs:element name="with_hierarchy_option" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_with"/>
      <xs:element ref="kw_hierarchy"/>
      <xs:element ref="kw_option"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element grant_privilege_statement / with_grant_option

Namespace

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

Diagram

Properties

content	complex
minOccurs	0

Model

kw_with , kw_grant , kw_option

Children

kw_grant, kw_option, kw_with

Instance

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

Source

<xs:element name="with_grant_option" minOccurs="0">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_with"/>
      <xs:element ref="kw_grant"/>
      <xs:element ref="kw_option"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>