Question 250
A newly created view should inherit predefined SELECT for approved reporting teams without manual follow-up. What grant pattern fits?
Explanation
Correct Answer
Correct: future-object grants. Future grants automatically apply defined object grants to matching objects created later.
Incorrect Answers
Not the best answer: Managed access schema centralizes grants on objects under the schema owner or role with MANAGE GRANTS; the scenario instead requires future-object grants.
Not the best answer: Database role groups privileges within a database scope for inheritance by account roles; the scenario instead requires future-object grants.
Not the best answer: Account role represents a role used by account users and across account-level privileges; the scenario instead requires future-object grants.