Schema documentation for component revoke_privilege

Showing:

Diagrams

Instances

Model

Properties

Source

Used by

Element revoke_privilege_statement

Namespace

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

Diagram

Properties

content

complex

Used by

Element

revoke_statement

Model

kw_revoke , revoke_option_extension{0,1} , privileges , kw_from , grantee+ , granted_by_grantor{0,1} , drop_behavior

Children

drop_behavior, granted_by_grantor, grantee, kw_from, kw_revoke, privileges, revoke_option_extension

Instance

<revoke_privilege_statement xmlns="http://www.sqlparser.com/xml/ansi2003">
  <kw_revoke>{1,1}</kw_revoke>
  <revoke_option_extension>{0,1}</revoke_option_extension>
  <privileges>{1,1}</privileges>
  <kw_from>{1,1}</kw_from>
  <grantee>{1,unbounded}</grantee>
  <granted_by_grantor>{0,1}</granted_by_grantor>
  <drop_behavior>{1,1}</drop_behavior>
</revoke_privilege_statement>

Source

<xs:element name="revoke_privilege_statement">
  <xs:complexType>
    <xs:sequence>
      <xs:element ref="kw_revoke"/>
      <xs:element ref="revoke_option_extension" minOccurs="0"/>
      <xs:element ref="privileges"/>
      <xs:element ref="kw_from"/>
      <xs:element ref="grantee" maxOccurs="unbounded"/>
      <xs:element ref="granted_by_grantor" minOccurs="0"/>
      <xs:element ref="drop_behavior"/>
    </xs:sequence>
  </xs:complexType>
</xs:element>