Posted by: Pdfprep
Post Date: January 5, 2021
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
Leave a Reply