-- This script should be run as sys.

set echo on;

-- still logged in as sys (or system or pyramed_owner)
-- make a 3 letter/number password and enter into mhs

CREATE USER fdbp5
IDENTIFIED BY country
DEFAULT TABLESPACE fdbp5
/
GRANT UNLIMITED TABLESPACE TO fdbp5
/
GRANT CONNECT TO fdbp5
/
GRANT DBA TO fdbp5
/
ALTER USER fdbp5 DEFAULT ROLE ALL
/

CREATE USER FDBP5_USER
IDENTIFIED BY country
DEFAULT TABLESPACE FDBP5;

grant connect to FDBP5_USER;
grant create session to FDBP5_USER;
grant create synonym to FDBP5_USER;

exit;
