Interested to Buy Any Domain ? << Click Here >> for more details...
What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
- 4 Answers
- 20426 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / guest
Granting BIND gives BIND authority on the Plan MK2 to all
users.
BIND PLAN establishes the relationship between DB2 and all
DBRMs or packages in that plan.
BIND(ADD) can be used for creating a new plan or package.
BIND(REPLACE) can be used when the program has been changed.
With this authority, any user is able to bind a DBRM or a
package to the plan MK2. The users can rebind the Plan as
well.
The Bind process performs the following :
1) Checks SQL syntax.
2) Checks security.
3) Compares column and table names against the DB2 Catalog.
4) Builds an access path strategy for each SQL statement.
Granting EXECUTE to PUBLIC gives all users, the authority
to EXECUTE the plan MK2.
Regards,
Amit
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the contents of a dclmgen?
What is the use of predicate?
How do I add a column to a table in db2?
What is bind package and plan in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are the bind parameters ibm db2?
What is innodb buffer pool?
Mention the downsides of page level lock.
What is db2 instance?
What is table space in db2?
How can we read records for specific member in CL? AND rpg?
What is db2 bind?
What is universal database?
What is copy pending status in db2?
What is ibm db2 client?
