Creating database schema users

Oracle Database schema users must be set up for use with IBM® Product Master.

Before you begin

Before you can create database schema users, you need the following user information:
  • Default table space: users.
  • Temporary table space: temp.
  • Authentication: Password.
  • Status: Unlocked.
  • Roles to be granted: Connect, and Resource.
  • System Privileges to be granted: unlimited table space, select any dictionary, query rewrite, and create any synonym.

About this task

You can create a database user for Product Master that is referenced in the common.properties file by using SQL commands.

Procedure

Run these SQL commands at the SQL prompt: 
  • SQL> Create user PIM identified by PIM default tablespace users temporary tablespace temp;

  • SQL> Grant create session, connect,resource,unlimited tablespace, select any dictionary, query rewrite, create any synonym to PIM;