Question 620
A platform governance committee considers: A role can create a view in a schema but analysts cannot SELECT from the newly created view. What preventive check should be standardized?
Explanation
Correct Answer
Add new-view grants to deployment templates and access test fixtures. This reduces recurrence of: Creation privileges do not automatically give unrelated roles read access to new objects. The verification should demonstrate: The consumer can read the created view without gaining access to base tables beyond design intent.
Incorrect Answers
Inventory service-user ownership and rotate credentials with controlled revocation tests. That safeguard is aimed at ANOTHER risk: A service user has a broad static password shared by multiple applications and audit cannot identify which app queried data. It is less targeted than the control for: Creation privileges do not automatically give unrelated roles read access to new objects.
Periodically verify new-object privilege behavior and future-grant overlap. That safeguard is aimed at ANOTHER risk: A project grants future objects manually each week and a newly created table is invisible to its application role. It is less targeted than the control for: Creation privileges do not automatically give unrelated roles read access to new objects.
Revalidate entitlement mapping after organizational restructures. That safeguard is aimed at ANOTHER risk: A regional sales analyst can read rows for every country despite having permission only for their own region. It is less targeted than the control for: Creation privileges do not automatically give unrelated roles read access to new objects.