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