Today's assessment question is also from Section 1: Database objects and Programming Methods (13%). Specifically, it tests this objective:
* Your ability to identify the more common privileges used when developing or running DB2 UDB applications.
The FINANCE application contains static SQL and issues the following statements:
SELECT name,id FROM prod.employee
UPDATE prod.dept SET dept=dept+1
INSERT INTO prod.dept VALUES(:id,:name)
Assuming a user can connect to the database, which of the following privileges must be granted to the user so that the FINANCE application can be run by that user?
A. UPDATE privilege on table DEPT
B. RUN privilege on tables EMPLOYEE and DEPT
C. EXECUTE privilege for the FINANCE application
D. CONTROL privilege on tables EMPLOYEE and DEPT
Where to find the answer:
1) Chapter 2 of Roger Sanders book: DB2(R) Universal Database V8.1 Certification Exam 703 Study Guide
2) Tutorial: http://www.ibm.com/software/data/education/selfstudy.html#2.
3) Product document: search on rivilegesand look up the following privileges: update, run, execute and control.