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.

Space allocation information

DBC.DiskSpace[X] This view gives AMP vproc information about disk space usage for any database or account. It gets this information from the ALL table.

DBC.TableSize[X] This view gives AMP vproc information about disk space usage (excluding spool) for any table or account.

DBC.AllSpace[X] This view gives AMP vproc information about disk space usage (including spool) for any database, table, or account. It also includes ALL table which should be excluded before summing.