For the application plan, you can grant access to selected users or all users (PUBLIC). The SQL GRANT command can be executed from within any SQL processor facility (such as IBM’s SPUFI). Specify the GRANT EXECUTE statement with the plan name you specified in the bind job.
If you created more than one plan for the adapter, you must grant permission for all of them. If you are unsure about the implications of the GRANT command, contact your Db2 database administrator.
If your user ID was the creator of the plan, you may also issue the GRANT statement from within the FOCUS environment. If you are using FOCUS, precede the GRANT statement with SQL DB2 or ENGINE DB2. To distribute EXECUTE privileges, issue:
GRANT EXECUTE ON plan TO {sqluserid1,sqluserid2...|PUBLIC} ;where:
Is the application plan created by the bind job.
Are authorized user IDs for individual users.
Allows all users to access the specified plan.
|
|
Information Builders |