Dropping Profiles | Teradata Vantage - 17.20 - Dropping Profiles - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572

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.