Creates or modifies a user and associates the user with the default compute cluster group using a user definition. You can either associate the user with the default compute cluster group while creating the user or after the user is created.
- 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
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 Using Privileges with CREATE USER.