Previous Topic: SQL StatementsNext Topic: SQL DML Statements

Privileges Required for Statements › SQL Statements › SQL DDL statements

SQL DDL statements

To execute CA IDMS SQL DDL statements, a user requires the privilege indicated in the following table if the resource type to which the privilege applies has been secured.

Note: Resource types QSCH, TABL, and AREA are secured when the DB resource type is secured.

Statement

Privilege required

Resource type

Resource name

CREATE CALC

ALTER(2)

TABL

table-identifier

DROP CALC

ALTER(2)

TABL

table-identifier

CREATE CONSTRAINT

 

ALTER(2)

REFERENCES

 

TABL

TABL

 

referencing-table-

identifier

referenced-table-

identifier

DROP CONSTRAINT

ALTER(2)

TABL

referencing-table- identifier

CREATE FUNCTION

CREATE(2)

TABL

function-identifier

ALTER FUNCTION

ALTER(2)

TABL

function-identifier

DROP FUNCTION

DROP(2)

TABL

function-identifier

CREATE INDEX

 

ALTER(2)

USE

 

TABL

AREA

 

table-identifier

segment-name.area-name

ALTER INDEX

ALTER(2)

TABL

table-identifier

DROP INDEX

ALTER(2)

TABL

table-identifier

CREATE PROCEDURE

CREATE(2)

TABL

procedure-identifier

ALTER PROCEDURE

ALTER(2)

TABL

procedure-identifier

DROP PROCEDURE

DROP(2)

TABL

procedure-identifier

CREATE SCHEMA(1)

CREATE

QSCH

schema-name

ALTER SCHEMA(1)

ALTER

QSCH

schema-name

DROP SCHEMA [CASCADE]

DROP

QSCH

schema-name

CREATE TABLE

 

CREATE(2)

USE

 

TABL

AREA

 

table-identifier

segment-name.area-name

ALTER TABLE

ALTER(2)

TABL

table-identifier

DROP TABLE [CASCADE]

DROP(2)

TABL

table-identifier

CREATE TABLE PROCEDURE

CREATE(2)

TABL

table-procedure-identifier

ALTER TABLE PROCEDURE

ALTER(2)

TABL

table-procedure-identifier

DROP TABLE PROCEDURE

DROP(2)

TABL

drop-procedure-identifier

CREATE VIEW

CREATE(2)

TABL

view-identifier

DROP VIEW [CASCADE]

DROP(2)

TABL

view-identifier

(1) If reference to a non-SQL-defined schema is made in the CREATE/ALTER SCHEMA statement, then the user must also hold either USE on NONSQL SCHEMA Vnnnn.schema-name or DBADMIN on the dictionary where the non-SQL-defined schema is stored. If DBNAME is specified, the user must hold USE on the named database; if not specified, the user must hold DBADMIN on the system dictionary.

(2) The owner of the associated schema implicitly holds the privilege.