Which package level privileges does the user smith have when the following statement is executed?

Which package level privileges does the user smith have when the following statement is executed?

GRANT ALL ON PACKAGE clct1.pkg1 TO smith;
A . GRANT, COPY, BIND, RUN
B . BIND, EXECUTE, COPY, RUN
C . CREATE, COPY, RUN, EXECUTE
D . COPY, BINDADD, SQL, EXECUTE

Answer: B

Explanation:

Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_grantpackageprivileges.html

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments