If you do not know which database user is mapped to which SAP B1 company database, see "Before add-on installation".
To grant the database user the privileges needed to create and maintain the BOY-IC-COMMON database when the SAP B1 server is running MSSQL do the following:
1.Open Microsoft SQL Server Management Studio.
2.Go to Security.
3.Go to Logins.
4.Right-click the relevant database user and select properties.
5.In Login Properties go to Securables.
6.Find the "Create any database" in the Explicit grid and check the "Grant" checkbox.
After the BOY-IC-COMMON database has been created
After the BOY-IC-COMMON database has been created by running the InterCompany add-on in one of the databases, all database users for companies that are going to be part of the InterCompany setup will need privileges to work with the BOY-IC-COMMON database. The only exception to this is the database user of the first company where the add-on was run, as this database user will be the creator of the database and thus already have full privileges.
To grant a database user privileges to work with BOY-IC-COMMON database do the following:
1.Open Microsoft SQL Server Management Studio.
2.Go to Security.
3.Go to Logins.
4.Right-click the relevant database user and select properties.
5.In Login Properties go to User Mapping.
6.In the "Users mapped to this login" grid check the map checkbox for BOY-IC-COMMON.
7.In the "Database role membership" grid check the db_owner checkbox.
