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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.