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