Create Oracle Database User for Inventory Management

  1. Navigate to the latest Inventory Management release 9.1 patch installation media, unzip Shell_DB_ORA_910.zip in <drive>:\IMSetup\Patch91x. There is a choice of either a Metric (MET) or Imperial (IMP) unit of measure shell database. See Mymaster Database for multi-tenant environments.

    Note:

    You must use the most recent patch to retrieve the shell database.
  2. Create a table space for Inventory Management. This should be completed by a database administrator familiar with the installation environment. See Sample Table Space Script for an example.
  3. A temporary table space and its name is required to exist.
  4. Open a command prompt with administrative privileges and connect to the database using the following command:
    sqlplus sys/<password>@<yourinstance> as sysdba
  5. Create new user for your Inventory Management installation. The user name must correspond to the short name of the Reporting and Analytics Organization.
    To find the short name, sign in to the M Organization of Reporting and Analytics, navigate to the M Org, click System, and then click Organizations.

    GRANT create session, resource, create view TO < User(Organization Short Name)> IDENTIFIED BY <password>;

    If there are multiple Inventory Management database users in the same environment, the password must be the same for all users.

  6. Configure the new user: ALTER USER <User(Organization Short Name)> DEFAULT TABLESPACE <Default Table Space Name> to use TEMPORARY TABLESPACE <Temporary Table Space Name>; ALTER USER <User(Organization Short Name)> QUOTA UNLIMITED ON < User(Organization Short Name);