The DEFINE Behavior

The DEFINE Behavior

As mentioned earlier, the definer is the user who will initiate the CREATE PROCEDURE statement to define the stored procedure in the DB2 subsystem. Thus, the define behavior has these characteristics:

• DB2 uses the authorization ID of the user-defined function or stored procedure owner for authorization checking of dynamic SQL statements in the application package.

• The default qualifier for unqualified objects is the user-defined function or stored procedure owner.