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)).
- Connect as the ADMIN user.
- Run the following SQL statement:
DROP USER user_name CASCADE;
user_name and the objects owned by that user.
Note:This removes all
user_nameobjects and the data owned by
You can also remove a database user with Oracle Database Actions. To remove a user, from the User Management page click the 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.