In this guide, I’ll show you how to create a new user in Oracle and give them the right permissions.

CREATE USER C##YOUR_NAME IDENTIFIED BY YOUR_PASSWORD;
grant unlimited tablespace to  C##YOUR_NAME;
grant resource, connect, dba to  C##YOUR_NAME;

This code needs to be executed by an admin user.