nerdexam
Oracle

1Z0-061 · Question #139

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

The correct answer is D. GRANT select ON dept. view the columns associated with the constraint names in the USER_CONS_COLUMNS view.

Controlling User Access

Question

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?

Options

  • AGRANT select ON dept
  • BGRANT select ON dept
  • CGRANT QUERY ON dept
  • DGRANT select ON dept

How the community answered

(57 responses)
  • A
    7% (4)
  • B
    4% (2)
  • C
    14% (8)
  • D
    75% (43)

Explanation

view the columns associated with the constraint names in the USER_CONS_COLUMNS view.

Topics

#GRANT#PUBLIC#SELECT privilege#object privileges

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-061 Practice