SQL$HELP_OLD72.HLB  —  GRANT_ANSI, Format
  GRANT  -----------> ----------+
  +-------------- <-------------+
  ++-> db-privs-ansi -------> ON DATABASE ALIAS ++-> <alias> -++-------------++
   |                                            |+--- , <-----+|             ||
   |                                            +----> * ------+             ||
   +-> table-privs-ansi ----> ON +----->----+---+++-> <table-name> -+--------+|
   |                             +-> TABLE -+   ||+-> <view-name> --+        ||
   |                                            |+-------- , <---------------+|
   |                                            +--------> * ----------------+|
   +-> column-privs-ansi ---> ON COLUMN ---+> <colunn-name> --+--------------+|
   |                                       +------- , <-------+              ||
   +-> module-privs-ansi ---> ON MODULE --++-> <module-name> --++------------+|
   |                                      |+------- , <--------+|            ||
   |                                      +-------> * ----------+            ||
   +-> ext-routine-privs-ansi -+> ON FUNCTION --+-++-><ext-routine-name> -++-+|
   |                           +> ON PROCEDURE -+ |+--------- , <---------+| ||
   |                                              +---------> * -----------+ ||
   +-> sequence-privs-ansi ---> ON SEQUENCE -++> <sequence-name> -++---------+|
                                             |+------- , <--------+|          |
                                             +-------> * ----------+          |
   +----------------------------<---------------------------------------------+
   +-> grant-ansi-to ---------------------------------------------------------->

  grant-ansi-to =

  ---> TO -+-+-> identifier-ansi-style ---+-+-+-----------------------+---->
           | +-> PUBLIC ------------------+ | +-> WITH GRANT OPTION --+
           +------------- , <---------------+

  db-privs-ansi =

  ----+---+-+-> SELECT -----+-+----+->
      |   | +-> INSERT -----+ |    |
      |   | +-> OPERATOR ---+ |    |
      |   | +-> DELETE -----+ |    |
      |   | +-> CREATE -----+ |    |
      |   | +-> ALTER ------+ |    |
      |   | +-> DROP -------+ |    |
      |   | +-> DBCTRL -----+ |    |
      |   | +-> DBADM ------+ |    |
      |   | +-> SHOW -------+ |    |
      |   | +-> REFERENCES -+ |    |
      |   | +-> UPDATE -----+ |    |
      |   | +-> SECURITY ---+ |    |
      |   | +-> DISTRIBTRAN + |    |
      |   +------- , <--------+    |
      +-------> ALL PRIVILEGES ----+

  table-privs-ansi =

  -+--+-+-> SELECT ---------------------------------+-+-+->
   |  | +-> INSERT ---------------------------------+ | |
   |  | +-> DELETE ---------------------------------+ | |
   |  | +-> CREATE ---------------------------------+ | |
   |  | +-> ALTER ----------------------------------+ | |
   |  | +-> DROP -----------------------------------+ | |
   |  | +-> DBCTRL ---------------------------------+ | |
   |  | +-> SHOW -----------------------------------+ | |
   |  | +-> REFERENCES  +---------------------------+ | |
   |  | |               +> ( +> <column-name> +> ) -+ | |
   |  | |                    +----- , <-------+     | | |
   |  | +-> UPDATE -+-------------------------------+ | |
   |  |             +> ( +> <column-name> --+--> ) -+ | |
   |  |                  +----- , <---------+         | |
   |  +------------------- , <------------------------+ |
   +------> ALL PRIVILEGES -----------------------------+

  column-privs-ansi =

  ---+-+-+-> UPDATE -----+-+--+-->
     | | +-> REFERENCES -+ |  |
     | +------- , <--------+  |
     +-----> ALL PRIVILEGES --+

  module-privs-ansi =

  -+--+-+-> ALTER ------------------------------+-+--+-->
   |  | +-> DBCTRL -----------------------------+ |  |
   |  | +-> DROP -------------------------------+ |  |
   |  | +-> EXECUTE ----------------------------+ |  |
   |  | +-> REFERENCES -------------------------+ |  |
   |  | +-> SHOW -------------------------------+ |  |
   |  +------------------- , <--------------------+  |
   +------> ALL PRIVILEGES --------------------------+

  ext-routine-privs-ansi =

  -+--+-+-> ALTER ------------------------------+-+--+-->
   |  | +-> DBCTRL -----------------------------+ |  |
   |  | +-> DROP -------------------------------+ |  |
   |  | +-> EXECUTE ----------------------------+ |  |
   |  | +-> REFERENCES -------------------------+ |  |
   |  | +-> SHOW -------------------------------+ |  |
   |  +------------------- , <--------------------+  |
   +------> ALL PRIVILEGES --------------------------+

  identifier-ansi-style =

  ----+-> uic-identifier ----+---->
      +-> user-identifier ---+
      +-> role-name ---------+

  sequence-privs-ansi =

  -+-+-+-> ALTER -----+-+-+-->
   | | +-> DBCTRL ----+ | |
   | | +-> DROP ------+ | |
   | | +-> SELECT ----+ | |
   | +------- , <-------+ |
   +--> ALL PRIVILEGES ---+
Close Help