List of All System Privileges

System privileges control the rights of users to perform authorized database tasks.

The following is a list of available system privileges:

• ACCESS SERVER LS
• ALTER ANY INDEX
• ALTER ANY MATERIALIZED VIEW
• ALTER ANY OBJECT
• ALTER ANY OBJECT OWNER
• ALTER ANY PROCEDURE
• ALTER ANY SEQUENCE
• ALTER ANY TABLE
• ALTER ANY TEXT CONFIGURATION
• ALTER ANY TRIGGER
• ALTER ANY VIEW
• ALTER DATABASE
• ALTER DATATYPE
• BACKUP DATABASE
• CHANGE PASSWORD
• CHECKPOINT
• COMMENT ANY OBJECT
• CREATE ANY INDEX
• CREATE ANY MATERIALIZED VIEW
• CREATE ANY OBJECT
• CREATE ANY PROCEDURE
• CREATE ANY SEQUENCE
• CREATE ANY TABLE
• CREATE ANY TEXT CONFIGURATION
• CREATE ANY TRIGGER
• CREATE ANY VIEW
• CREATE DATATYPE
• CREATE EXTERNAL REFERENCE
• CREATE MATERIALIZED VIEW
• CREATE MESSAGE
• CREATE PROCEDURE
• CREATE PROXY TABLE
• CREATE TABLE
• CREATE TEXT CONFIGURATION
• CREATE VIEW
• DEBUG ANY PROCEDURE
• DELETE ANY TABLE
• DROP ANY INDEX
• DROP ANY MATERIALIZED VIEW
• DROP ANY OBJECT
• DROP ANY PROCEDURE
• DROP ANY SEQUENCE
• DROP ANY TABLE
• DROP ANY TEXT CONFIGURATION
• DROP ANY VIEW
• DROP CONNECTION
• DROP DATATYPE
• DROP MESSAGE
• EXECUTE ANY PROCEDURE
• LOAD ANY TABLE
• INSERT ANY TABLE
• MANAGE ANY DBSPACE
• MANAGE ANY EVENT
• MANAGE ANY EXTERNAL ENVIRONMENT
• MANAGE ANY EXTERNAL OBJECT
• MANAGE ANY LDAP SERVER
• MANAGE ANY LOGIN POLICY
• MANAGE ANY MIRROR SERVER
• MANAGE ANY OBJECT PRIVILEGES
• MANAGE ANY SPATIAL OBJECT
• MANAGE ANY STATISTICS
• MANAGE ANY USER
• MANAGE ANY WEB SERVICE
• MANAGE AUDITING
• MANAGE MULTIPLEX
• MANAGE PROFILING
• MANAGE REPLICATION
• MANAGE ROLES
• MONITOR
• READ CLIENT FILE
• READ FILE
• REORGANIZE ANY OBJECT
• SELECT ANY TABLE
• SERVER OPERATOR
• SET ANY PUBLIC OPTION
• SET ANY SECURITY OPTION
• SET ANY SYSTEM OPTION
• SET ANY USER DEFINED OPTION
• SET USER (granted with administrative rights only)
• TRUNCATE ANY TABLE
• UPDATE ANY TABLE
• UPGRADE ROLE
• USE ANY SEQUENCE
• VALIDATE ANY OBJECT
• WRITE CLIENT FILE
• WRITE FILE