SET PROFILE Now Applies Constraints for Passed Profiles

Why it matters

Previously, applying a profile using SET PROFILE did not enforce any resource or query constraints associated with that profile. This feature ensures that when a profile is applied, all its constraints are also enforced, providing better control and security over query execution based on user profiles.

How to use it

Use the SET PROFILE 'profile_name' statement in your SQL session to apply the profile along with its constraints to your queries.