CDC Guide for Linux, UNIX, and Windows

10.5.1
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Granting Additional Permissions

In addition to the default permissions, you must grant the SAP HANA CDC user INSERT permission on their schema to the target database and SELECT permission to the user on the source database schema and tables.

The following command allows the target database to insert the triggers required to capture data to the PKLOG table:

GRANT INSERT ON SCHEMA INFA_CDC TO database_name;

To grant permissions on the target database, you can either grant the permissions directly to the SAP HANA CDC user or create a user role and assign the SAP HANA CDC user to the role. Whichever method you choose, the user must have SELECT permissions on all tables in the source database that are registered for change data capture.

If you want to capture data from all or most tables in a database, issue the following command to grant access to all objects in the target database:

GRANT SELECT ON SCHEMA database_name TO INFA_CDC;
GRANT TRIGGER ON SCHEMA database_name TO INFA_CDC;

If you want to capture data from just a few tables, you can limit access to only those tables. Issue the following command for each registered table:

GRANT SELECT ON database.table_name TO INFA_CDC; 
GRANT TRIGGER ON database.table_name TO INFA_CDC;

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Granting Additional Permissions

Granting Additional Permissions