Previous Topic: SQL DML StatementsNext Topic: User-Defined System Security Rules

Privileges Required for Statements › SQL Statements › Access Module Management Statements

Access Module Management Statements

To execute access module management statements a user requires the privilege indicated in the following table or must own the schema associated with the access module, if the database has been secured.

If the owner lacks one or more applicable table access privileges for SQL statements in the RCMs included in the access module when it is created or altered, a warning is issued. If privileges are lacking at runtime, an error occurs when the user attempts to execute the access module.

Statement

Privilege required

Resource type

Resource name

CREATE ACCESS MODULE

CREATE

DACC

schema-name.access- module-name

ALTER ACCESS MODULE

ALTER

DACC

schema-name.access- module-name

DROP ACCESS MODULE

DROP

DACC

schema-name.access- module-name

EXPLAIN ACCESS MODULE

DISPLAY

DACC

schema-name.access- module-name