Interested to Buy Any Domain ? << Click Here >> for more details...
What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
- 4 Answers
- 20242 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 is cascading rollback?
How to execute stored procedures?
How many types of page locks can be held in db2?
How many databases can be created inside an instance in db2 ?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is alias in db2?
How to take backup of table in db2?
What is reorg and runstats in db2?
How do I optimize a query in db2?
What is catalog database in db2?
What is the role of schema in the db2 database?
What is the use of db2 optimizer?
Define declaration generator (dclgen).
What does db2 blu stand for?
When reorg is used?
