Set User Default Schema

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.


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


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.

Was this article helpful?
0 out of 0 found this helpful