Access rights and their abbreviations

Access rights and their abbreviations, (partial list):

DATABASE = CREATE (CD) + DROP (DD)

USER = CREATE (CU) + DROP (DU)

TABLE = CREATE (CT) + DROP (DT)

VIEW = CREATE (CV) + DROP (DV)

MACRO = CREATE (CM) + DROP (DM)

TRIGGER = CREATE (CG) + DROP (DG)

PROCEDURE = CREATE (PC) + DROP (PD)

FUNCTION = CREATE (CF) + DROP (DF)

INDEX Table Column IX

REFERENCES Table Column RF

SELECT/RETRIEVE Table or View R

UPDATE Table or View U

INSERT Table or View I

DELETE Table or View D

EXECUTE Macro E

CHECKPOINT Journal Tables CP

DUMP Data and/or Journal Tables DP

RESTORE Data and/or Journal Tables RS

CREATE ROLE Create a role CR

DROP ROLE Drop a role DR

CREATE PROFILE Create a profile of user attributes CO

DROP PROFILE Drop a profile of user attributes DO

CREATE PROCEDURE Stored procedure PC

DROP PROCEDURE Stored procedure PD

EXECUTE PROCEDURE Stored procedure PE

SET SESSION RATE SS

SET RESOURCE RATE SR

ABORT SESSION AS

MONITOR RESOURCE MR

MONITOR SESSION MS

Note:-
The RESTORE statement also allows the recipient to execute ROLLBACK, ROLLFORWARD, and DELETE JOURNAL commands in the ARC facility.

The DROP allows COMMENT ON and COLLECT STATISTICS on the object.