Sets the default schema name for a user. When a user logs in or changes repositories, Magpie will attempt to set the current schema to the user's default schema. If the user's default schema is not set or if it does not exist, Magpie will fall back to using the repository's default schema.

Syntax

alter user <user reference>
  set default schema { <schema reference> | none }

Parameters

user reference

String. Name of the user to set the default schema for.

schema reference

String. Name of the new default schema to set. Specify "none" to unset the default schema.