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]