Interested to Buy Any Domain ? << Click Here >> for more details...
What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
- 4 Answers
- 20322 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
How will you return the number of records in table?
What is the latest version of ibm db2?
How do you stop a db2 database in linux?
Can you use max on a char column?
How to find primary key of a table in db2?
Mention the downsides of page level lock.
What kind of database is db2?
What is db2 plan table?
What are bind parameters in db2?
Why do we use cursor?
How do I import data from excel to db2?
On which levels locks can be applied?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Give a brief description of db2 isolation levels?
What are the various data types available in db2?
