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
- 13734 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 are db2 objects?
What happens in bind step in a db2 program?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is a cursor in programming?
How to find the maximum value in a column in the db2 database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the use of with ur in db2?
What is phantom read in db2?
How will you return the number of records in table?
How to restart a DB2 program?
What is the result of open cursor statement?
What is an instance database?
What are foreign keys in db2?
What is the clustering index in the db2 database?
What is the maximum size of varchar data type in db2?
