You can create profiles to define resource parameters for groups of users with similar needs, rather than defining them for individual users. Then specify the profile name in a CREATE or MODIFY USER statement to give users membership in the profile.
Profiles specify such parameters as:
- Spool space and temporary space allocations
- Password control settings
- Default database assignment
- User account assignments
- Row level security constraint assignments