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

Posted by: Pdfprep Category: C2090-320 Tags: , ,

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

Your email address will not be published.