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
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is view db2?
How to get the ddl of a table in db2?
What is a trigger in the db2 database?
What is declare cursor?
what is diffrence b/w file-aid tool and file-aid utility???
What are the benefits of using the db2 database?
What does db2 blu stand for?
How can you count the number of rows from a table tab?
What types of tables are there in the db2 database?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Explain about mirror activator disk mirroring?
Mention the different locking levels that are available in db2.
Is the primary key a clustered index?
How can we retrieve the total number of records in RPG & CLLE?