“It's always been, and always will be the same in the world: the horse does the work, and the coachman is tipped.”
It is easy to get mixed up between a Profile and a Role. Think of it as “Profiles are for People” and “Roles are for Rights”.
Profiles define system attributes for users (people). By assigning a profile to a group of users, you can rest assured that all group members will operate under a common set of attributes.
Create a different profile for each user group, based on system attributes that members share.
If you do set the value of a parameter in the profile the settings override the settings for the user in a CREATE USER or MODIFY USER statement.
If you do not set the value of a parameter, ...