Remove Users with Autonomous Transaction Processing

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

For example, connect using Oracle SQL Developer (see Connect with Oracle SQL Developer (earlier than Version 18.2)).

  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.