16.10 - Dropping Profiles - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
Content Type
Publication ID
English (United States)

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.