CREATE PROFILE 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]