CREATE USER SQL Statement | Teradata Vantage - CREATE USER - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

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™ - Analytics Database 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.