Description

Modify user attributes, set the user's default execution cluster and default Schema

Syntax

ALTER USER user_name SET
[DEFAULT_VCLUSTER= vc_name] 
[DEFAULT_SCHEMA=schema_name]

1.DEFAULT_VCLUSTER: Specifies the default computing resource for the user. If not specified, the global default computing resource will be used.

2.DEFAULT_SCHEMA: Specifies the default schema for the user. If the user does not specify a default schema, they need to specify the schema to access when logging in, otherwise an error will occur. If a default schema is specified, the user will use this schema by default when logging in. The USE command can be used to switch to other schemas during the session. Priority: USE command > default schema.