Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  REVOKE_ANSI, Format
  REVOKE -----------------------+
  +---------------<-------------+
  ++-> db-privs-ansi -------> ON DATABASE ALIAS -++-> <alias> -++-----------++
   |                                             |+--- , <-----+|           ||
   |                                             +---> * -------+           ||
   +-> table-privs-ansi ----> ON +----->----+--++-+-> <table-name> +++------+|
   |                             +-> TABLE -+  || +-> <view-name> -+||      ||
   |                                           |+--------- , <------+|      ||
   |                                           +---------> * --------+      ||
   +-> column-privs-ansi ---> ON COLUMN ---+->  <column-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> -++-------+|
                                            |+-------- , <---------+|        |
                                            +--------> * -----------+        |
   +----------------------------<--------------------------------------------+
   +-> revoke-ansi-from ------------------------------------------------------>

  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 --------------------------+

   sequence-privs-ansi =

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

  revoke-ansi-from =

  --> FROM -+-+-> identifier-ansi-style ---++-->
            | +-> PUBLIC ------------------+|
            +------------- , <--------------+

  identifier-ansi-style =

  ------> user-identifier -------->
Close Help