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

  grant-to =

  --> TO ++-> identifier --+-+------------------------------+-+--->
         |+-> PUBLIC ------+ +-> AFTER -+-> identifier ---+-+ |
         |                   |          +-> PUBLIC -------+ | |
         |                   +-> POSITION <n> --------------+ |
         +-------------------- , <----------------------------+

  db-privs =

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

  table-privs=

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

  column-privs=

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

  module-privs =

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

  ext-routine-privs =

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

  sequence-privs =
  -+--> ALL --+-----------------+---+-->
   |          +--> PRIVILEGES --+   |
   +++-> ALTER --+-+----------------+
    |+-> DROP  --+ |
    |+-> SELECT -+ |
    +----- , <-----+

  identifier =

  --+-+-> user-identifier ----+-+->
    | +-> general-identifier -+ |
    | +-> system-identifier  -+ |
    | +-> role-name ----------+ |
    +------------ + <-----------+
Close Help