This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

 

Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Granting privileges by generating SQL

You can generate SQL to re-create a set of privileges on an object or a set of privileges held by an authorization ID

You can use the BATCH parameter with the DCL command. Generating-JCL-for-a-job-in-batch explains the procedure for generating a job by using the DESCRIBE command. You can use a similar procedure by substituting the DCL command.

Note

The generated SQL includes only privileges that are explicitly granted.

To grant privileges

Issue the DCL line command against one of the source objects in the following table:

Object code

Object

CI

Collection ID

DB

Database

DT

Data or distinct type

FN

Function

MQT

Materialized query tables

NP

Native SQL stored procedures

PG

Package

PL

Plan

PR

Procedure

SC

Schema

SE

Identity columns in sequences

SG

Storage group

SU

System privileges for AUTHIDs

TB

Table

TS

Table space

UA

User authorization

US

User

VW

View


Related topic

Managing-authorizations


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*