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
- 13705 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
Define db2 and its databases?
Explain what are the various isolation levels possible?
What do you mean by commit and rollback?
What is host variable?
Who uses db2?
How to check last update on table in db2?
How do you find the maximum value in a column in db2?
What is null indicator in cobol db2?
What is a bind in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
Which command is used to remove all rows from a table?
What's The Error Code For Unique Index Voilation?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How do I delete a column in db2?
What types of tables are there in the db2 database?
