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