Drop the Storage and Revoke Database User Permissions
If you have dropped all database components in a schema, you can drop the storage and revoke the database user permissions.
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.
a. 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.
b. 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.