What is necessary for your query on an existing view to execute successfully?

The correct answer is B. You need SELECT privileges on the view. To query an existing view you need to have SELECT privileges on the view. Incorrect Answers A: The underlying tables can be without data: view will work correctly in that case. C: The underlying tables can be in different user schema. D: You need SELECT privileges not only on…

Controlling User Access

Question

Options

AThe underlying tables must have data.
BYou need SELECT privileges on the view.
CThe underlying tables must be in the same schema.
DYou need SELECT privileges only on the underlying tables.

How the community answered

(22 responses)

A
5% (1)
B
77% (17)
C
14% (3)
D
5% (1)

Explanation

To query an existing view you need to have SELECT privileges on the view. Incorrect Answers A: The underlying tables can be without data: view will work correctly in that case. C: The underlying tables can be in different user schema. D: You need SELECT privileges not only on the underlying tables, but on the view also.

Topics

#SELECT privilege#view access#object privileges#user permissions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice