B2B Data Exchange Installation and Configuration Guide

10.5.3
- 10.5.0
- 10.4.0
- 10.2.3
- 10.2.2 HotFix 1
- 10.2.1
- 10.2

Back Next

Database User Privileges

When you prepare the production database and history database, you assign database privileges to users according to the archive scenario requirements. Set up the database users before you install the accelerator and create archive projects.

To avoid user conflicts, set up a unique database user for each database.

The following table describes the production database privileges to assign to the production database user:

Component	Privileges
Rows	Select Insert Update Delete
Tables and views	Create Alter Drop

The following table describes the history database privileges to assign to the history database user:

Component	Privileges
Rows	Select Insert Update Delete
Tables and views	Create Alter Drop
Synonyms and links	Create Delete

In addition to the history database privileges, the history database user needs to access and modify rows in the production database.

The following table describes the production database privileges to assign to the history database user:

Component	Privileges
Rows	Select Insert Update Delete

Rename Saved Search

Table of Contents

B2B Data Exchange Installation and Configuration Guide

B2B Data Exchange Installation and Configuration Guide

Database User Privileges

Database User Privileges