Use the DROP PROFILE statement to delete a profile. For sessions that log on after the profile is dropped:
- Spool and temporary space settings revert to the default settings.
- Account and database settings default to the settings defined for the affected user.
- Any password attributes defined in the profile default to the global password settings.
- The system does not enter a NULL for profile_name in the user definition. Therefore, if you recreate a profile with the same name as a dropped profile, the user is subject to the profile parameters at the next logon.