INSTALLATION OF IBM COGNOS 8.4.1 (Part-2)

Once the installation of Cognos and samples is ready, we can proceed to the next step, that is creating the users in Oracle.

Creating Users in Oracle:

(1) Click Start -> Programs -> Oracle Database 10g Express Edition -> Go To Database Home Page.

(2) Enter the Database User name as "SYSTEM" and the password.

(3) In the following the command area, type the following commands one by one and click on "Run". 

create user cognos identified by cognos;

create user gosales identified by cognos;

create user gosalesdw identified by cognos;

create user gosaleshr identified by cognos;

create user gosalesrt identified by cognos;

create user gosalesmr identified by cognos;

grant dba to cognos;

grant dba to gosales;

grant dba to gosalesdw;

grant dba to gosaleshr;

grant dba to gosalesrt;

grant dba to gosalesmr;

Note: In the above command, "user" means the schema, and "identified by" means the password.