|
Explanation: To query an existing view you need to have SELECT privileges on the view. Incorrect Answers: 1: The underlying tables can be without data: view will work correctly in that case. 3: The underlying tables can be in different user schema. 4: You need SELECT privileges not only on the underlying tables, but on the view also. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 356-359 Chapter 8: User Access Control in Oracle
|