CREATE PROFILE [ database_name. ] profile_name [ AS profile ] [;]
-
profile
-
{ ACCOUNT = { 'account_string' | ('account_string' [,...] ) | NULL } |
DEFAULT MAP = { map_name | NULL } [ OVERRIDE [NOT] ON ERROR ] |
DEFAULT DATABASE = { database_name | NULL } |
SPOOL = { { n | constant_expression } [BYTES] | NULL } |
TEMPORARY = { { n | constant_expression } [BYTES] | NULL } |
PASSWORD [ATTRIBUTES] = { (attribute [,...]) | NULL } |
QUERY_BAND = 'pair [...]' [ ([NOT] DEFAULT) ] |
IGNORE QUERY_BAND VALUES = 'pair [...]' |
TRANSFORM ( transformation [,...] ) |
COST PROFILE = { cost_profile_name | NULL } |
CONSTRAINT = constraint_specification [,...]
} [,...]
-
attribute
-
attribute_name = { value | NULL }
-
pair
-
pair_name = pair_value;
-
transformation
-
data_type = group_name
-
constraint_specification
-
rls_constraint_column_name
( { level_specification [,...] | category_name [,...] | NULL } )
-
level_specification
-
level_name [DEFAULT]