Notifications
Clear all

2302616 - Validation - SAP HANA database user privileges

1 Posts
1 Users
0 Likes
316 Views
admin
Posts: 350
Admin
Topic starter
(@admin)
Prominent Member
Joined: 3 years ago

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

Reply
Share:
x  Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security