CREATE USER user_name [ FROM database_name ] AS
{ PERMANENT | PERM } = n [BYTES] [ skew_specification ] [,]
PASSWORD = temp_password [,]
[ user_attribute [[,]...] ] [;]
-
skew_specification
-
SKEW = { constant_expression | DEFAULT } [PERCENT]
-
user_attribute
-
{ STARTUP = 'string;' |
{ TEMPORARY | SPOOL } = { n | constant_expression } [BYTES] [ skew_specification ] |
DEFAULT DATABASE = database_name |
COLLATION = collation_sequence |
ACCOUNT = { 'account_string' | ( 'account_string' [,...] ) | NULL } |
DEFAULT MAP = { map_name | NULL } [ OVERRIDE [NOT] ON ERROR ] |
[NO] FALLBACK [PROTECTION] |
[ NO | DUAL ] [BEFORE] JOURNAL |
[ NO | DUAL | [NOT] LOCAL ] AFTER JOURNAL |
DEFAULT JOURNAL TABLE = [ database_name. ] table_name |
TIME ZONE = { LOCAL | [ sign ] 'quotestring' | 'time_zone_string' | NULL } |
DATEFORM = { INTEGERDATE | ANSIDATE | NULL } |
DEFAULT CHARACTER SET server_character_set |
DEFAULT ROLE = { role_name | NONE | NULL | ALL } |
PROFILE = { profile_name | NULL } |
TRANSFORM ( transform_specification [,...]) |
DBA |
CONSTRAINT = constraint [,...] |
EXPORTWIDTH { 'export_definition_name' | DEFAULT }
}
-
transform_specification
-
data_type = group_name
-
constraint
-
row_level_security_constraint_column_name {
( { level_name [DEFAULT] | category_name } [,...]) |
(NULL)
}