- Create new schema or user and grant resource
CREATE USER spagobi IDENTIFIED BY spagobi;
grant connect, resource to spagobi;
- Change Password User
ALTER USER hr IDENTIFIED BY hr
- HR sample database script
alter user hr account unlock;
grant connect, resource to hr;
ALTER USER hr IDENTIFIED BY hr;