Database Objects for Oracle

About this task

Create a local user on the Oracle host: user name build and password build.
  • Add appropriate grants, including CREATE SESSION and CREATE TABLE.
  • Add an appropriate QUOTA size in the DEFAULT TABLESPACE, to provide enough space for the system to store data.
create user build
    identified by password
    default tablespace users
    quota unlimited on users;

grant create session, create table
    to build;
Important: During installation, the same value is used for the database name and the Oracle SID. A limitation in JDBC drivers requires this constraint. If they are not the same, the Quick Report reporting feature and the services-layer APIs for Java and Perl do not work.

Feedback