DDL Statements

Privileges Required for Statements › DDL Statements

DDL Statements

DISPLAY Statements

To execute a DISPLAY statement on a physical database entity requires one of these privileges if the dictionary and the resource type of the entity has been secured:

DISPLAY privilege on the entity
DBADMIN privilege on the dictionary where the entity is defined

This table shows what privilege is required to execute a DISPLAY statement when the indicated resource type has been secured:

Statement	Privilege required	Resource type	Resource name
DISPLAY SEGMENT	DISPLAY	DB	segment-name
DISPLAY FILE	DISPLAY	DB	segment-name
DISPLAY AREA	DISPLAY	DB	segment-name
DISPLAY DMCL	DISPLAY	DMCL	dmcl-name
DISPLAY[JOURNAL] BUFFER	DISPLAY	DMCL	dmcl-name
DISPLAY ARCHIVE/DISK/TAPE JOURNAL	DISPLAY	DMCL	dmcl-name
DISPLAY DBTABLE	DISPLAY	DBTB	dbtable-name
DISPLAY DBNAME	DISPLAY	DBTB	dbtable-name

Definition Statements

To execute the physical database definition statements in the following table requires:

DBADMIN privilege on the dictionary where the physical database definition is stored, if that dictionary has been secured.
The privileges indicated in the following table, if the resource types have been secured.

The privileges must be granted in a session that is connected to the system dictionary.

Statement	Privilege required	Resource type	Resource name
CREATE SEGMENT	CREATE	DB	segment-name
ALTER SEGMENT	ALTER	DB	segment-name
DROP SEGMENT	DROP	DB	segment-name
CREATE FILE	ALTER	DB	segment-name
ALTER FILE	ALTER	DB	segment-name
DROP FILE	ALTER	DB	segment-name
CREATE AREA	ALTER	DB	segment-name
ALTER AREA	ALTER	DB	segment-name
DROP AREA	ALTER	DB	segment-name
CREATE DMCL	CREATE	DMCL	dmcl-name
ALTER DMCL... DBTABLE name	ALTER USE	DMCL DBTB	dmcl-name dbtable-name
DROP DMCL	DROP	DMCL	dmcl-name
GENERATE DMCL	ALTER	DMCL	dmcl-name
CREATE [JOURNAL] BUFFER	ALTER	DMCL	dmcl-name
ALTER [JOURNAL] BUFFER	ALTER	DMCL	dmcl-name
DROP [JOURNAL] BUFFER	ALTER	DMCL	dmcl-name
CREATE ARCHIVE/DISK/TAPE JOURNAL	ALTER	DMCL	dmcl-name
ALTER ARCHIVE/DISK/TAPE JOURNAL	ALTER	DMCL	dmcl-name
DROP ARCHIVE/DISK/TAPE JOURNAL	ALTER	DMCL	dmcl-name
CREATE DBTABLE	CREATE	DBTB	dbtable-name
ALTER DBTABLE	ALTER	DBTB	dbtable-name
DROP DBTABLE	DROP	DBTB	dbtable-name
GENERATE DBTABLE	ALTER	DBTB	dbtable-name
CREATE DBNAME	CREATE ALTER	DB DBTB	database-name dbtable-name
ALTER DBNAME	ALTER ALTER	DB DBTB	database-name dbtable-name
DROP DBNAME	DROP ALTER	DB DBTB	database-name dbtable-name