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

CREATE USER user_name [ FROM database_name ] AS
  { PERMANENT | PERM } = n [BYTES] [ skew_specification ] [,]
  PASSWORD = temp_password | WITHOUT PASSWORD [,]
  [ user_attribute [[,]...] ] [;]

skew_specification

SKEW = { constant_expression | DEFAULT } [PERCENT]

user_attribute

{ STARTUP = 'string;' |

  { TEMPORARY | SPOOL } = { n | constant_expression } [BYTES] [ skew_specification ] |

  DEFAULT DATABASE = database_name |

  COLLATION = collation_sequence |

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

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

  [NO] FALLBACK [PROTECTION] |

  [ NO | DUAL ] [BEFORE] JOURNAL |

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

  DEFAULT JOURNAL TABLE = [ database_name. ] 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 [,...]) |

  DBA |

  CONSTRAINT = constraint [,...] |

  EXPORTWIDTH { 'export_definition_name' | DEFAULT }
}

transform_specification

data_type = group_name

constraint

row_level_security_constraint_column_name {
  ( { level_name [DEFAULT] | category_name } [,...]) |
  (NULL)
}