Removing schemas

Use the Remove Privileges to Schema from window to remove privileges for a user ID for objects defined by a schema. The schema name is usually the same as the user ID.

Authorities and privileges

To remove a schema:

  1. Open the Remove Privileges to Schema window.
  2. In the list box, ensure that the schema name that you want to remove is selected.
  3. Click OK to remove the schema and close the window.

Related information

About granting and revoking privileges