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