A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses

A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the view uses
A . TRUE
B. FALSE

View Answer

Answer: A

Explanation:

A user who has SELECT privilege on a view does not also need SELECT privilege on the tables that the

view uses. This means that you can use a view to give a role access to only a subset of a table. For example, you can create a view that accesses medical billing information but not medical diagnosis information in the same table, and you can then grant privileges on that view to the "accountant" role so that the accountants can look at the billing information without seeing the patient’s diagnosis. Operating on a view also requires the USAGE privilege on the parent database and schema.