If you want to apply a different policy than the default profile, create a new profile and assign it to the user.

The pgx_create_profile function creates a profile.

To assign a profile to a user, use the pgx_assign_profile_to_user function.

Users with CREATEROLE privilege can create and assign profiles.

Refer to "B.3.1 Profile Management Functions" and "B.3.2 User Management Functions" for functions.