MODIFY 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) ] | ( [NOT] DEFAULT ) | NULL }
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
row_level_security_constraint_name ({ level_specification [,...] | category_name [,...] | NULL })
- level_specification
level_name [DEFAULT]