GRANT -----------> ----------+
+-------------- <-------------+
++-> db-privs-ansi -------> ON DATABASE ALIAS ++-> <alias> -++-------------++
| |+--- , <-----+| ||
| +----> * ------+ ||
+-> table-privs-ansi ----> ON +----->----+---+++-> <table-name> -+--------+|
| +-> TABLE -+ ||+-> <view-name> --+ ||
| |+-------- , <---------------+|
| +--------> * ----------------+|
+-> column-privs-ansi ---> ON COLUMN ---+> <colunn-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> -++---------+|
|+------- , <--------+| |
+-------> * ----------+ |
+----------------------------<---------------------------------------------+
+-> grant-ansi-to ---------------------------------------------------------->
grant-ansi-to =
---> TO -+-+-> identifier-ansi-style ---+-+-+-----------------------+---->
| +-> PUBLIC ------------------+ | +-> WITH GRANT OPTION --+
+------------- , <---------------+
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 --------------------------+
identifier-ansi-style =
----+-> uic-identifier ----+---->
+-> user-identifier ---+
+-> role-name ---------+
sequence-privs-ansi =
-+-+-+-> ALTER -----+-+-+-->
| | +-> DBCTRL ----+ | |
| | +-> DROP ------+ | |
| | +-> SELECT ----+ | |
| +------- , <-------+ |
+--> ALL PRIVILEGES ---+