MS SQL
Create and configure a user account, which will be used by Inventory Service to connect to the database. This account will also be used by default to initiate the database, and later to update it. In order to do that, the account must have permission to create/update/remove tables in the database! The account must also be able to run stored procedures. In MS SQL Server, permission should be set to “db_owner”.
Oracle
For Oracle 9, Start DBAStudio (or Enterprise Manager) and create a new Tablespace that is at least 100MB.
Create a new user in the folder Security à Users, e.g. NNS your new Tablespace as Default Tablespace.
For Oracle 10, start Database Control and create a new Tablespace, add a data file that is at least 100MB, choose AUTOEXTEND and Increment e.g. 10240 KB.
Create a new user in the folder Security à Users, e.g. NNS and choose your new Tablespace as Default Tablespace, choose also Temporary Tablespace e.g. TEMP.
Go to the tab Role and add RESOURCE, the CONNECT role is there already.
Go to the System Privileges tab and add CREATE PUBLIC SYNONYM, CREATE ANY PROCEDURE and UNLIMITED TABLESPACE.
A Service Name pointing to the database server also has to configured, in Oracle Net Manager on the server where this module shall be installed.