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.
- Passwordless user
- 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 Security Administration, B035-1100.
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.
Privileges Granted Automatically
See Privileges Granted Automatically to a Created User and Privileges Not Granted Automatically.