Dropping Profiles | Teradata Vantage - 17.10 - Dropping Profiles - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
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.