Remove Database Users

To remove users from your database, connect to the database as the ADMIN user using any SQL client tool.

  1. As the ADMIN user run the following SQL statement:
    DROP USER user_name CASCADE;

This removes user_name and the objects owned by that user.

Note:

This removes all user_name objects and the data owned by user_name is deleted.