17.05 - Effects of Dropping a Profile - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Dropping an active profile may have undesirable effects on profile member users. Teradata recommends that you use assign a new profile to the affected users before dropping their current profile. See MODIFY USER.

If you drop an active profile:
  • Profile members continue to have the profile defined in their user definitions. If you later recreate a profile with the same name, the profile is again active for profile members.
  • Space, account, and default database settings for the dropped profile immediately default to the corresponding settings in the user definition. If the user definition does not have a specific setting, the setting for the owning database or user becomes the default.
  • Password control attributes default to the corresponding global settings defined in DBC.SysSecDefaults.
  • If you drop a profile used to assign security policy, the policy no longer applies to profile member users. For information on how to assign security policy to database profile objects in a directory, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.