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)).
- 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