When is the authorization check on DB2 objects done - at
BIND time or run time?
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
How to find the number of rows in db2 tables?
What is package in cobol db2?
How does coalesce work?
Which component is responsible for processing sql statements and selecting access paths?
Explain how can you do the explain of a dynamic sql statement?
What is difference between isnull and coalesce?
How does a cursor work?
How to rename a table in DB2 ?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How do you select a row using indexes in db2?
What are the two types of logging in the db2 database? Explain them.
How to check table size in db2 sap?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the physical storage length of timestamp data type?
What is the cobol picture clause of the db2 data types date, time, timestamp?