REVOKE -----------------------+ +---------------<-------------+ ++-> db-privs-ansi -------> ON DATABASE ALIAS -++-> <alias> -++-----------++ | |+--- , <-----+| || | +---> * -------+ || +-> table-privs-ansi ----> ON +----->----+--++-+-> <table-name> +++------+| | +-> TABLE -+ || +-> <view-name> -+|| || | |+--------- , <------+| || | +---------> * --------+ || +-> column-privs-ansi ---> ON COLUMN ---+-> <column-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> -++-------+| |+-------- , <---------+| | +--------> * -----------+ | +----------------------------<--------------------------------------------+ +-> revoke-ansi-from ------------------------------------------------------> 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 --------------------------+ sequence-privs-ansi = -+-+-+-> ALTER -------------------------------+-+--+---> | | +-> DBCTRL ------------------------------+ | | | | +-> DROP --------------------------------+ | | | | +-> REFERENCES --------------------------+ | | | | +-> SELECT ------------------------------+ | | | | +-> SHOW --------------------------------+ | | | +------- , <---------------------------------+ | +--> ALL PRIVILEGES ------------------------------+ revoke-ansi-from = --> FROM -+-+-> identifier-ansi-style ---++--> | +-> PUBLIC ------------------+| +------------- , <--------------+ identifier-ansi-style = ------> user-identifier -------->