16.10 - Dropping Profiles - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.