nerdexam
IBM

C2090-320 · Question #91

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

The correct answer is B. BIND, EXECUTE, COPY, RUN. packageprivileges.html

Security and Authorization

Question

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

Options

  • AGRANT, COPY, BIND, RUN
  • BBIND, EXECUTE, COPY, RUN
  • CCREATE, COPY, RUN, EXECUTE
  • DCOPY, BINDADD, SQL, EXECUTE

How the community answered

(40 responses)
  • A
    8% (3)
  • B
    85% (34)
  • C
    5% (2)
  • D
    3% (1)

Explanation

packageprivileges.html

Topics

#GRANT ALL#package privileges#BIND#EXECUTE

Community Discussion

No community discussion yet for this question.

Full C2090-320 Practice