Edit a schema

Edit a SQL schema or self-schema.

You may need to edit a SQL schema to add users and/or admins to the schema. If you have created a self-schema, you will be the only one with user or admin access. You will need to edit it to allow others user or administrator access.
Note: The examples throughout this section use the default SQL database catalog tenten.
  1. Navigate to the Schemas tab.
  2. In the Schema name drop-down list, select the schema to edit.
  3. Add or edit the Description, if desired.
  4. Add or delete Users to/from the schema.
    To add a user, enter the user ID of the user and press Enter (PC) or Return (Mac). To delete a user, click the Close () icon next to the user name.
    The Save changes to this schema button appears if you make any changes to the schema.
  5. Click Save changes to this schema.

    Two User IDs are added as Users and Admins of the schema.