Drop the Storage and Revoke Database User Permissions

Edit online

About this task

If you have dropped all database components in a schema, you can drop the storage and revoke the database user permissions.

Procedure

  1. In the Action area, in the Type list, click drop. Then click Component and select All.
  2. In the Connection area, click the RDBMS from which to drop the database components, type the URL for the RDBMS, and specify the database user and password to use to connect to the RDBMS.
  3. Select the Drop tablespaces and database user check box.
    1. In the Admin ID field, identify the database user or operating system user that has database administrator credentials to drop the database user and storage. Supply the password for the database user in the Admin password field.
    2. The next field depends on your RDBMS.
    RDBMS Fields and Entries
    DB2, Oracle, or Tibero In the Tablespace directory field, identify the directory that contains the tablespaces to drop. If you specified custom tablespace names, supply those names in the Tablespaces area.
    MySQL or SQL Server In the Database field, specify the database that contains the storage.
  4. Click Execute.