How to Drop Profiles | Database Administration | Teradata VantageCloud Lake - Dropping Profiles - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

DROP statements are recorded in the Data Dictionary. However, the result of a DROP PROFILE, DROP DATABASE, or DROP ROLE statement is not cascaded to the user rows in DBC.Dbase, so the corresponding default setting for each affected user is not reset to NULL. When an affected user next logs on, the system does not return an error or warning.

If you drop a default profile, the system uses the following by default:
  • ACCOUNT, SPOOL, TEMP, and DEFAULT DATABASE specifications in the CREATE USER or latest MODIFY USER statement
  • Password attributes defined at the system level in DBC.SecurityDefaultsV (see SecurityDefaultsV)
If you drop and recreate a profile with the same name, users defined for that profilename are assigned the profile parameters at the next logon. The effect of a profile recreation is not immediate.