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
- 13613 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
Explain the contention situations caused by locks?
can we view the access paths created by dbrm ? how ? thx
What is nvl in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
When reorg is used?
What is db2 command?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Can one database have multiple instances?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What are the uses of db2 optimizer?
What is the maximum size of a char data type in db2?
What are the various isolation levels possible?
What are the various data types available in db2?
What is consistency token in db2?
