Using the Catalog Synchronization Utility › Specifying Control Statements for CADB2SY2 › Specifying GRANT TO PUBLIC Control Statements › Syntax › Example of GRANT TO PUBLIC Control Statement

Example of GRANT TO PUBLIC Control Statement

Suppose you want your synchronization to grant the following system and resource privileges to the DB2 authorization ID PUBLIC:

• The TRACE and DISPLAY system privileges
• The SELECT privilege for the catalog tables
• The EXECUTE privilege for the sample dynamic SQL plan
• The STATS, STARTDB, and STOPDB privileges on the DEVTEST database
• The USE privilege on all storage groups that start with TEST.

To provide these privileges to PUBLIC, you can use these GRANT TO PUBLIC control statements in the //PUBLIC file for the CADB2SY2 execution.

SYS(TRACE)
SYS(DISPLAY)
TBL(SYSIBM‑) PRIV(SELECT)
PLN(DSNTIA‑) PRIV(EXECUTE)
DBS(DEVTEST) PRIV(STATS,STARTDB,STOPDB)
STG(TEST‑) PRIV(USE)

The PRIV(USE) keyword is optional for the STG statement because storage groups have only one privilege.