Explicit schema privileges

You can explicitly grant privileges on schemas.

Begin general-use programming interface information.

Db2 supports the following schema privileges:

Table 1. Explicit schema privileges
Schema privileges Operations available for usage
CREATEIN Create distinct types, user-defined functions, triggers, and stored procedures in the designated schemas
ALTERIN Alter user-defined functions or stored procedures, or specify a comment for distinct types, user-defined functions, triggers, and stored procedures in the designated schemas
DROPIN Drop distinct types, user-defined functions, triggers, and stored procedures in the designated schemas
End general-use programming interface information.