Use primary role for authorizing view and materialized view creation (Canceled)¶
Attention
This BCR is canceled and removed from the 2024_08 Bundle (Disabled by Default).
When this behavior change bundle is enabled, the creation of a view or materialized view behaves as follows:
- Before the change:
When creating a view or materialized view, the primary and all secondary roles are considered when checking the privileges of the SQL definition.
- After the change:
When creating a view or materialized view, only the primary role is considered when checking the privileges of the SQL definition.
Ref: 1782