When is the authorization check on DB2 objects done - at
BIND time or run time?
- 1 Answers
- 13045 Views
- I also Faced
- E-Mail Answers
Answer Posted / shyam
In the Plans or packages which has the Static SQL's,
Authorization check is done based on the VALIDATE parameter
in BIND control card ..If VALIDATE(BIND), Authorization
check is done during the BIND time. If VALIDATE(RUN),
Authorization check is done during the run time.
For the plans or packages having Dynamic SQL's ,
Authorization check is done during the run time.
Shyam
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
What is db2 plan table?
Explain about dbrm.
Explain about rct.
what is a corelated subquerry?
What is null value in db2?
How do you pull up a query which was previously saved in qmf?
How to find the number of rows in db2 tables?
How do I copy a table in db2?
What is bind package and plan in db2?
What is db2 connect?
What does runstats do in db2?
What is reorg?
What is the maximum number of columns in a db2 table?
What is dbrm library?
What is the purpose of using commit?
