nerdexam
IBM

C2090-558 · Question #114

User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?

The correct answer is B. EXECUTE on the procedure. See the full explanation below for the reasoning.

Question

User A creates a User Defined Routine (UDR). Which privilege must be granted to other users before they can run user A's UDR?

Options

  • ADBA on the database
  • BEXECUTE on the procedure
  • CRESOURCE on the database
  • DSELECT on the tables used in the procedure

How the community answered

(32 responses)
  • A
    13% (4)
  • B
    75% (24)
  • C
    9% (3)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full C2090-558 Practice