CA Ideal Commands › ASSIGN AUTHORIZATION Command (SQL Access)

ASSIGN AUTHORIZATION Command (SQL Access)

The ASSIGN AUTHORIZATION (SQL Access) command overrides the authorization ID specified in the program resource table for a dataview for DB2 or in the environment fill‑in for a program using CA Datacom SQL access.

For DB2 access: This command lets you change the authorization ID used to qualify tables or views accessed by a program without having to change the program definition. The command is issued before running a program that executes in dynamic mode and before generating the plan for a program that executes in static mode. (Issuing the command before running a program in static mode has no effect.)

For CA Datacom SQL access: This command is issued before running a program to select an alternate plan at runtime. As a result, the statements in the new plan are executed instead of the statements in the default plan.

This command has the following format:

                     {UNQUALIFIED}     {UNQUALIFIED}
ASSIGN AUTHORIZATION {auth‑id1   } NEW {auth‑id2   }