Using Drop User Tool

Drop user tool

This database tool will drop the main OSM database user cow_owner and therefore all objects (tables and packages) owned by the cow_owner will also be deleted. The database users cow_user and cow_read will also be dropped.

Purpose of operation

Important This operation should never be performed on a live production database.

This tool is only used to clean up a test environment when recreating a database from scratch.

In that scenario, the following steps can be followed.

1. Drop cow_owner user.

2. Recreate database by performing all steps.

3. Load data from DMP file.

4. Run OSM privileges.

Warning

There is no recovery. This operation cannot be undone.

Drop cow_user from OSM database

5. Click Drop cow_owner.

   

6. A confirmation message appears. Click Yes to proceed.

   

   While the operation is in progress, you will see several messages, such as the following messages.

   Dropping cow_read from database..

   

   Dropping cow_user from database..

   

   Dropping cow_owner from database..

   

   When the operation is finished, you will see the following dialog box.

   

7. Click Close to close the tool.