DEV Community

abdullah khrais
abdullah khrais

Posted on

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;

Enter fullscreen mode Exit fullscreen mode

This code needs to be executed by an admin user.

Top comments (0)