SQL$HELP_OLD72.HLB  —  REVOKE  Format
  REVOKE -----------------------+
  +-----------------------------+
  ++-> 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-rout-name> -++-+ |
   |                      +-> ON PROCEDURE -+|+----------- , <-----+| | |
   |                                         +-----------> * -------+ | |
   +-> sequence-privs --> ON SEQUENCE -++-><sequence-name> -++--------+ |
                                       |+------- , <--------+|          |
                                       +-------> * ----------+          |
  +---------------------------------------------------------------------+
  +-> revoke-from ------------------------------------------------------->

  db-privs=

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

  table-privs=

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

  column-privs =

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

  module-privs =

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

  ext-routine-privs =

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

  sequence-privs =

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

  revoke-from =

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

  identifier =

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