The following table columns used are in the privileges table:
- Privilege: Name of the privilege.
- Abbreviation in System Views: Two-letter code used in system views to represent each privilege granted on a particular object. The AccessRight column in the following views lists privileges for users and roles:
- DBC.AllRightsV
- DBC.UserGrantedRightsV
- DBC.UserRightsV
- DBC.AllRoleRightsV
- DBC.UserRoleRightsV
- Automatically Granted: Creators: When you create a user or database, the system automatically grants you privileges on the created user or database.
- Automatically Granted: Created User or Database: When you create a user or database, it automatically gets certain privileges on itself.
- Explicitly Granted: Creators: When you create a user, you do not automatically receive certain privileges on the user.
- Explicitly Granted: Created User or Database: Although the system automatically grants many database privileges, some privileges are only available to users if you explicitly grant them. You must have the WITH GRANT OPTION privilege on these privileges before you can grant them.
- Privilege Category: Functional area of privilege.
The following table lists information about the privileges available for users and databases.
| Privilege | Abbreviation in System Views | Automatically Granted | Explicitly Granted | |||
|---|---|---|---|---|---|---|
| Creators | Created User or Database | Creators | Created User or Database | Privilege Category | ||
| ABORT SESSION or ABORTSESSION | AS | No | No | Yes | Yes | Monitor |
| ALTER EXTERNAL PROCEDURE | AE | No | No | Yes | Yes | |
| ALTER FUNCTION | AF | No | No | Yes | Yes | |
| ALTER PROCEDURE | AP | No | No | Yes | Yes | |
| ANY | AN | Yes | Yes | No | No | Indicates a HELP or SHOW statement for which at least one privilege, but no specific privilege, is required. |
| CHECKPOINT | CP | Yes | Yes | No | No | |
| CONNECT THROUGH | No | No | Yes | Yes | Trusted session-related | |
| CONSTRAINT ASSIGNMENT | SA | No | No | Yes | Yes | System-level |
| CONSTRAINT DEFINITION | SD | No | No | Yes | Yes | System-level |
| CREATE AUTHORIZATION | CA | Yes | Yes | No | No | |
| CREATE DATABASE | CD | Yes | No | No | Yes | |
| CREATE DATASET SCHEMA | C1 | No | No | Yes | Yes | Dataset Schema |
| CREATE EXTERNAL PROCEDURE | CE | No | No | Yes | Yes | |
| CREATE FUNCTION | CF | No | No | Yes | Yes | |
| CREATE GLOP | GC | No | No | Yes | Yes | Global and Persistent (GLOP) Data |
| CREATE MACRO | CM | Yes | Yes | No | No | |
| CREATE MAP | MC | No | No | Yes | Yes | System-level |
| CREATE OWNER PROCEDURE | OP | No | No | Yes | Yes | |
| CREATE PROCEDURE | PC | No | No | Yes | Yes | |
| CREATE PROFILE | CO | No | No | Yes | Yes | System-level |
| CREATE ROLE | CR | No | No | Yes | Yes | System-level |
| CREATE SERVER | CS | No | No | Yes | Yes | |
| CREATE TABLE | CT | Yes | Yes | No | No | |
| CREATE TRIGGER | CG | Yes | Yes | No | No | |
| CREATE USER | CU | Yes | No | No | Yes | |
| CREATE VIEW | CV | Yes | Yes | No | No | |
| CREATE ZONE | CZ | No | No | Yes | Yes | System-level |
| CTCONTROL | TH | No | No | Yes | Yes | Trusted session-related |
| DELETE | D | Yes | Yes | No | No | |
| DROP AUTHORIZATION | DA | Yes | Yes | No | No | |
| DROP DATABASE | DD | Yes | No | No | Yes | |
| DROP DATASET SCHEMA | D1 | Yes | No | Yes | Yes | Dataset Schema |
| DROP FUNCTION | DF | Yes | Yes | No | No | |
| DROP GLOP | GD | No | No | Yes | Yes | Global and Persistent (GLOP) Data |
| DROP MACRO | DM | Yes | Yes | No | No | |
| DROP MAP | MD | No | No | Yes | Yes | System-level |
| DROP PROCEDURE | PD | Yes | Yes | No | No | |
| DROP PROFILE | DO | No | No | Yes | Yes | System-level |
| DROP ROLE | DR | No | No | Yes | Yes | System-level |
| DROP SERVER | DS | No | No | Yes | Yes | |
| DROP TABLE | DT | Yes | Yes | No | No | |
| DROP TRIGGER | DG | Yes | Yes | No | No | |
| DROP USER | DU | Yes | No | No | Yes | |
| DROP VIEW | DV | Yes | Yes | No | No | |
| DROP ZONE | DZ | No | No | Yes | Yes | System-level |
| DUMP | DP | Yes | Yes | No | No | |
| EXECUTE | E | Yes | Yes | No | No | |
| EXECUTE FUNCTION | EF | No | No | Yes | Yes | |
| EXECUTE PROCEDURE | PE | No | No | Yes | Yes | |
| GLOP MEMBER | GM | No | No | Yes | Yes | Global and Persistent (GLOP) Data |
| INDEX | IX | No | No | Yes | Yes | Table-level |
| INSERT | I | Yes | Yes | No | No | |
| MONITOR RESOURCE or MONRESOURCE | MR | No | No | Yes | Yes | Monitor |
| MONITOR SESSION or MONSESSION | MS | No | No | Yes | Yes | Monitor |
| NONTEMPORAL | NT | No | No | Yes | Yes | Temporal |
| OVERRIDE DELETE | OD | No | No | Yes | Yes | Security Constraint Override |
| OVERRIDE DUMP | OA | No | No | Yes | Yes | Security Constraint Override |
| OVERRIDE INSERT | OI | No | No | Yes | Yes | Security Constraint Override |
| OVERRIDE RESTORE | OR | No | No | Yes | Yes | Security Constraint Override |
| OVERRIDE SELECT | OS | No | No | Yes | Yes | Security Constraint Override |
| OVERRIDE UPDATE | OU | No | No | Yes | Yes | Security Constraint Override |
| REFERENCES | RF | No | No | Yes | Yes | Table-level |
| RESTORE | RS | Yes | Yes | No | No | |
| RETRIEVE/SELECT | R | Yes | Yes | No | No | |
| SET RESOURCE RATE or SETRESRATE | SR | No | No | Yes | Yes | Monitor |
| SET SESSION RATE or SETSESSRATE | SS | No | No | Yes | Yes | Monitor |
| SHOW | SH | No | No | Yes | Yes | |
| STATISTICS | ST | Yes | Yes | No | No | Also for creators of tables |
| UDT METHOD or UDTMETHOD | UM | No | No | Yes | Yes | UDT |
| UDT TYPE or UDTTYPE | UT | No | No | Yes | Yes | UDT |
| UDT USAGE or UDTUSAGE | UU | No | No | Yes | Yes | UDT |
| UPDATE | U | Yes | Yes | No | No | |
| WITH DATASET SCHEMA | W1 | Yes | No | Yes | Yes | Dataset Schema |
| ZONE OVERRIDE | ZO | No | No | No | No | System-level |