Remove Users on Autonomous Database

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. Connect as the ADMIN user.
  2. 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.

You can also remove a database user with Oracle Database Actions. To remove a user, from the User Management page click the Object submenu icon to open the context menu for a user, and then select Delete. See Manage Users and User Roles on Autonomous Database - Connecting with SQL Developer Web for more information on using Oracle Database Action User Management.