GRANT -------------------------+ +------------------------------+ ++-> 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-routine-name> ++| | +> ON PROCEDURE +|+----------- , <-------+|| | +-----------> * ---------+| +-> sequence-privs --> ON SEQUENCE -++> <sequence-name> -++------+ |+------------ , <---+| | +------------> * -----+ | +---------------------------<-------------------------------------+ +-> grant-to ------------------------------------------------------> grant-to = --> TO ++-> identifier --+-+------------------------------+-+---> |+-> PUBLIC ------+ +-> AFTER -+-> identifier ---+-+ | | | +-> PUBLIC -------+ | | | +-> POSITION <n> --------------+ | +-------------------- , <----------------------------+ db-privs = ----+---+-+-> SELECT -----+-+----+-> | | +-> INSERT -----+ | | | | +-> OPERATOR ---+ | | | | +-> DELETE -----+ | | | | +-> CREATE -----+ | | | | +-> ALTER ------+ | | | | +-> DROP -------+ | | | | +-> DBCTRL -----+ | | | | +-> DBADM ------+ | | | | +-> SHOW -------+ | | | | +-> REFERENCES -+ | | | | +-> UPDATE -----+ | | | | +-> SECURITY ---+ | | | | +-> DISTRIBTRAN + | | | +------- , <--------+ | +-------> ALL PRIVILEGES ----+ table-privs= -+--+-+-> SELECT -------------------------------+-+-+-> | | +-> INSERT -------------------------------+ | | | | +-> OPERATOR -----------------------------+ | | | | +-> DELETE -------------------------------+ | | | | +-> CREATE -------------------------------+ | | | | +-> ALTER --------------------------------+ | | | | +-> DROP ---------------------------------+ | | | | +-> DBCTRL -------------------------------+ | | | | +-> SHOW ---------------------------------+ | | | | +-> REFERENCES +--------------------------+ | | | | | +> ( +> <column-name> +> ) + | | | | | +----- , <-------+ | | | | | +-> UPDATE +------------------------------+ | | | | +> ( +> <column-name> -+---> ) + | | | | +----- , <--------+ | | | +------------------- , <----------------------+ | +------> ALL PRIVILEGES ---------------------------+ column-privs= ---+-+-+-> UPDATE -----+-+--+--> | | +-> REFERENCES -+ | | | +------- , <--------+ | +-----> ALL PRIVILEGES --+ module-privs = -+--+-+-> ALTER ------------------------------+-+--+--> | | +-> DBCTRL -----------------------------+ | | | | +-> DROP -------------------------------+ | | | | +-> EXECUTE ----------------------------+ | | | | +-> REFERENCES -------------------------+ | | | | +-> SHOW -------------------------------+ | | | +------------------- , <--------------------+ | +------> ALL PRIVILEGES --------------------------+ ext-routine-privs = -+--+-+-> ALTER ------------------------------+-+--+--> | | +-> DBCTRL -----------------------------+ | | | | +-> DROP -------------------------------+ | | | | +-> EXECUTE ----------------------------+ | | | | +-> REFERENCES -------------------------+ | | | | +-> SHOW -------------------------------+ | | | +------------------- , <--------------------+ | +------> ALL PRIVILEGES --------------------------+ sequence-privs = -+--> ALL --+-----------------+---+--> | +--> PRIVILEGES --+ | +++-> ALTER --+-+----------------+ |+-> DROP --+ | |+-> SELECT -+ | +----- , <-----+ identifier = --+-+-> user-identifier ----+-+-> | +-> general-identifier -+ | | +-> system-identifier -+ | | +-> role-name ----------+ | +------------ + <-----------+