To deploy and run a database ingestion task that includes a SAP HANA source, the source connection must specify a database user who has the privileges to read the following monitoring and system views:
SYS.M_DATABASE
SYS.M_CS_PARTITIONS
SYS.SCHEMAS
SYS.TABLES
SYS.TABLE_COLUMNS
SYS.INDEXES
SYS.INDEX_COLUMNS
For incremental load tasks, grant the following privileges:
To enable the Mass Ingestion Databases user to write information about captured changes to the PKLOG table and to write change data to the shadow _CDC tables, execute the following grant statement:
GRANT INSERT ON SCHEMA
schema_name
TO [
user_id
|
user_role
];
This statement grants the INSERT permission on the schema to the user that runs insert, update, and delete operations on the base source tables.
GRANT INSERT ON SCHEMA
schema_name
TO [
schema_user
];
This statement grants the INSERT privilege on the schema where the PKLOG, PROCESSED, and shadow _CDC tables exist to the schema (as the user) where the triggers exist. This permission enables triggers to run with the permissions held by the schema where the triggers exist.
If you want to capture data from all or most tables in a database, execute the following statement to grant access to all objects in the source database:
GRANT SELECT ON SCHEMA
schema_name
TO [
user_id
|
];
GRANT TRIGGER ON SCHEMA
schema_name
TO [
user_id
|
user_role
];
If you want to capture data from just a few tables, you can limit access to only those tables by executing the following statement for each selected source table:
GRANT SELECT ON
database
.
table_name
TO [
user_id
|
user_role
];
GRANT TRIGGER ON
database
.
table_name
TO [
user_id
|
user_role
];
ASK INFAPreview
