Create Oracle Database user with required privileges

Create Oracle Database user with required privileges

Use the following Oracle SQL to create a database user with the typical privileges to connect and work with the database:

CREATE USER dbusername IDENTIFIED BY dbuserpassword;
GRANT CONNECT TO dbusername;
GRANT CONNECT, RESOURCE TO dbusername;
GRANT UNLIMITED TABLESPACE TO dbusername;
Advertisements