2302616 - Validation - SAP HANA database user privileges

Symptom

To install, upgrade, and use SAP Business One, you must grant the following database privileges to the corresponding SAP HANA database user:

Roles:

• PUBLIC
• CONTENT_ADMIN
• AFLPM_CREATOR_ERASER_EXECUTE

System privileges:

• CREATE SCHEMA (grantable)
• USER ADMIN (grantable)
• ROLE ADMIN (grantable)
• CATALOG READ (grantable)
• IMPORT
• EXPORT
• INIFILE ADMIN
• LOG ADMIN
  This is needed if this database user is used to run the migration wizard to migrate your company databases from the Microsoft SQL Server to the SAP HANA server.

SQL object privileges:

• SYSTEM schema: CREATE ANY, SELECT
• _SYS_REPO schema: SELECT, EXECUTE, DELETE (all grantable)

The SBOCOMMON schema is created during the installation of SAP Business One Server, and the COMMON schema is created during the installation of the analytics platform. If you use different SAP HANA users for installing different components, you must pay special attention to grant the following object privileges as appropriate:

• SBOCOMMON schema: SELECT, INSERT, DELETE, UPDATE, EXECUTE (all grantable)
• COMMON schema: SELECT, INSERT, DELETE, UPDATE, EXECUTE (all grantable)

For further details please check the Administrator's Guide, chapter 9.3.3

Solution

Recommendation