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

Syntax

Begin each control statement anywhere in columns 1 through 72. You can use columns 73 through 80 for sequence numbers because these columns are ignored. Specify at least one blank between keywords. Specify comments between /* and */ anywhere in columns 2 through 71. Do not continue control statements to a second line, instead, begin again with the control statement on the next line to specify additional user or resource information in a batch.

Here is the format of the GRANT TO PUBLIC statement:

{BPL(bufferpool|bufferpoolmask)            }
{COL(collection|collectionmask)            }
{DBS(database|databasemask)                }
{FNC(function|functionmask)                }
{JAR(jarfile|jarfilemask)                  }
{PKG(package|packagemask)                  }
{PLN(plan|planmask)                        }   PRIV(privilege[,privilege...] )
{PRC(procedure|proceduremask)              }
{SCH(schema|schemamask)                    }
{SEQ(sequence|sequencemask)                }
{STG(storagegroup|storagegroupmask)        }
{SYS(systemprivilege|systemprivilegemask)  }
{TBL(table|tablemask)                      }
{TSP(tablespace|tablespacemask)            }
{TYP(distincttype|distinctypemask)         }

For resources that have only one privilege, such as buffer pools, storage groups and table spaces, the PRIV keyword can be omitted. In addition, you do not need the PRIV keyword to define system privileges that the SYS resource type specified. Instead, use the name of the system privilege as the resource name. For example, the system privilege SYSADM is defined as SYS(SYSADM). You can specify only one system privilege or system privilege mask per GRANT TO PUBLIC statement.