16.20 - CREATE USER - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

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™ NewSQL Engine Security Administration, B035-1100.

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

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.

Syntax