Create a database and grant access

As the DBA, create a database (mlssample), connect to it, and grant access to the users. The DSO does not need access to the created database.

SYSTEM.ADMIN(DSO)=> \c system dba dddd
You are now connected to database system as user dba.
SYSTEM.ADMIN(DBA)=> CREATE DATABASE mlssample;
CREATE DATABASE
SYSTEM.ADMIN(DSO)=> GRANT CONNECT ON mlssample to sw1,sw2,engmgr;
GRANT
SYSTEM.ADMIN(DBA)=> \c mlssample dba dddd
You are now connected to database mlssample as user dba.