CREATE MODIFY USER Syntax | Teradata Database - MODIFY USER Syntax - Teradata Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Database
Release Number
20.00
Published
June 2025
ft:locale
en-US
ft:lastEdition
2026-09-23
dita:mapPath
mbm1747160743883.ditamap
dita:ditavalPath
jlp1749501702948.ditaval
dita:id
mdr1472255012272
lifecycle
latest
MODIFY USER user_name AS user_attribute [[,]...] [;]
user_attribute
{ { PERMANENT | PERM | TEMPORARY | SPOOL } = { n | constant_expression } [BYTES]
     [ SKEW { constant_expression | DEFAULT } [PERCENT]] |

  STARTUP = { NULL | quotestring } |

  PASSWORD = password [FOR USER] |

  RELEASE PASSWORD LOCK |

  ACCOUNT = { 'account_string' | ('account_string' [,...]) | NULL } |

  DEFAULT MAP = { map_name | NULL } [ OVERRIDE [NOT] ON ERROR ] |

  DEFAULT DATABASE = database_name |

  COLLATION = collation_sequence |

  [NO] FALLBACK [PROTECTION] |

  [ NO | DUAL ] [BEFORE] JOURNAL |

  [ NO | DUAL | [NOT] LOCAL ] AFTER JOURNAL |

  DEFAULT JOURNAL TABLE = [ database_name. ] table_name |

  DROP DEFAULT JOURNAL TABLE [ = table_name ] |

  TIME ZONE = { LOCAL | [sign] 'quotestring' | 'time_zone_string' | NULL } |

  DATEFORM = { INTEGERDATE | ANSIDATE | NULL } |

  DEFAULT CHARACTER SET server_character_set |

  DEFAULT ROLE = { role_name | NONE | NULL | ALL } |

  PROFILE = { profile_name | NULL } |

  TRANSFORM ( [ transform_specification [,...] ] ) |

  [NOT] DBA |

  EXPORTWIDTH { 'export_definition_name' | DEFAULT } |

  CONSTRAINT = constraint [,...] |

  WITHOUT PASSWORD
}
transform_specification
data_type = group_name
constraint
row_level_security_constraint_column_name {
  ( { level_name [DEFAULT] | category_name } [,...]) |
  (NULL)
}