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