Assume user anderson has a spool setting of 500,000 bytes and user brewster has a spool setting of 800,000 bytes.
User anderson can create a profile named finance with a spool setting of 500,000 bytes.
CREATE PROFILE finance AS SPOOL = 500000;
User anderson can assign this profile to user brewster, effectively reducing the spool limit from 800,000 to 500,000 bytes.
MODIFY USER brewster AS PROFILE = finance;
If the owner of anderson later increases the spool allotment to 1,000,000, anderson can also increase the finance profile spool setting up to 1,000,000 bytes. All users assigned that profile, including brewster, automatically get 1,000,000 bytes of spool space.
MODIFY PROFILE finance AS SPOOL = 1000000;
If the owner of anderson later decreases the spool allotment back to 500,000 bytes, the finance profile and the allotment for brewster are not affected.