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
Latest C2090-320 Practice Questions with 123 Q&As
Updated Study Material | Instant Download | Detailed Answers and Explanations
Subscribe
Login
0 Comments