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
- 13739 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 is bind package and plan in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is a plan and package in db2?
What is a db2 tablespace?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is blu acceleration in db2?
How can you classify the locks in db2?
Is db2 free?
What is dbrm?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is syscat in db2?
Define data page.
How to execute stored procedure in db2 command editor?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is bind and rebind in db2?
