Schema documentation for component grant_role

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element grant_role_statement

Namespace

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

Diagram

Properties

content

complex

Used by

Element	grant_statement
Element Group	access_control

Model

kw_grant , role_granted+ , kw_to , grantee+ , with_admin_option{0,1} , granted_by_grantor{0,1}

Children

granted_by_grantor, grantee, kw_grant, kw_to, role_granted, with_admin_option

Instance

<grant_role_statement xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_grant>{1,1}</kw_grant>
  <role_granted>{1,unbounded}</role_granted>
  <kw_to>{1,1}</kw_to>
  <grantee>{1,unbounded}</grantee>
  <with_admin_option>{0,1}</with_admin_option>
  <granted_by_grantor>{0,1}</granted_by_grantor>
</grant_role_statement>

Source

<xs:element name="grant_role_statement">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_grant"/>
      <xs:element ref="role_granted" maxOccurs="unbounded"/>
      <xs:element ref="kw_to"/>
      <xs:element ref="grantee" maxOccurs="unbounded"/>
      <xs:element name="with_admin_option" minOccurs="0">
        <xs:complexType>
          <xs:sequence>
            <xs:element ref="kw_with"/>
            <xs:element ref="kw_admin"/>
            <xs:element ref="kw_option"/>
          </xs:sequence>
        </xs:complexType>
      </xs:element>
      <xs:element ref="granted_by_grantor" minOccurs="0"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>

Element grant_role_statement / with_admin_option