15.10 - CREATE USER - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Purpose

Defines a permanent Teradata Database user, 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 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.
  • One or more row-level security constraints.

For information about definition and administration of external (directory-based) users, see 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