Resources › DB2PLAN Resource Class—Secure DB2 Plans › Examples: DB2PLAN resource class

Examples: DB2PLAN resource class

This example gives the Engineering Department (ENGDEPT) ownership of the plan SR19052P:

TSS ADDTO(ENGDEPT) DB2PLAN(SR19052P)

This example removes ownership of the plan SR19052P:

TSS REMOVE(ENGDEPT) DB2PLAN(SR19052P)

This example authorizes USRMIKE to bind on plan SR19052P:

TSS PERMIT(USRMIKE) DB2PLAN(SR15092P) ACCESS(BIND)

This example revokes USRMIKE's Authority to plan SR19052P:

TSS REVOKE(USRMIKE) DB2PLAN(SR19052P)