Exam4Training

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

Exit mobile version