Interested to Buy Any Domain ? << Click Here >> for more details...
When is the authorization check on DB2 objects done - at
BIND time or run time?
- 1 Answers
- 13725 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How does a cursor work?
What is the use of runstats in db2?
What is null in db2?
what is consistency token
how can u understand the end of the table ?
what is datacom db?
what is plan? is plan executable or package?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
Where is the output of EXPLAIN stored?
How can deadlocks be resolved?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
How do I copy a table in db2?
COBOL 
