CREATE USER SQL Statement | Teradata Vantage - 17.05 - CREATE USER - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
English (United States)
Last Update

Creates a permanent database user object, in which other database objects may be created, with a mandatory permanent space allocation and a mandatory password plus optional attributes.

Optional attributes can include:
  • Startup string.
  • Maximum spool space assignment.
  • Maximum temporary space assignment.
  • Default database.
  • Default collation sequence.
  • Default account.
  • Default map.
  • Default level of fallback protection.
  • Before journaling.
  • After journaling.
  • Default journal table.
  • Default time zone.
  • Default date form type.
  • Default server character set.
  • Default role.
  • Profile.
  • Transform group.
  • One or more row-level security constraints.

For information about definition and administration of external (directory-based) users, see Teradata Vantage™ - Advanced SQL Engine Security Administration, B035-1100.

Where a specific setting exists in the user definition and the assigned user profile, the profile setting takes precedence.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

CREATE USER is functionally similar to the ANSI SQL:2011 CREATE SCHEMA statement.

Required Privileges

To create a user, you must have the CREATE USER privilege on the immediate owner database or user.

To include a profile specification, you must have the DROP PROFILE privilege.

To include the CONSTRAINT = row_level_security_constraint_name option in a CREATE USER statement, you must also have the CONSTRAINT ASSIGNMENT privilege.

For more information, see Privileges Received by the Creator.