[Qlik Compose][Oracle source]Permission for Source database and Landing zone

[iti-attunity-sup]

Hello support team.

[Info]
Source : Oracle

[Question]
In following manual, Oracle user permission is not written clearly.
Would you tell me what permission is need for Source database and Landing zone.

https://help.qlik.com/en-US/compose/November2023/Content/ComposeDWDL/Main/DW/Data%20Source%20Connect...
https://help.qlik.com/en-US/compose/November2023/Content/ComposeDWDL/Main/DW/Data%20Source%20Connect...

I would like to know permission name.

Best Regards.

[sureshkumar]

Hello @iti-attunity-sup 

I would suggest giving similar permission given at Qlik Replicate for Oracle Endpoint.

As in the user guide mentioned, kindly make sure we have "Select from tables" and Read Metadata i.e In Model section we try to discover the tables from the landing zone for that we need "select from tables" permission.

After displaying the table(s), To read the metadata i.e columns defined for the table and Whether column is defined PK, FK or not

Regards,
Suresh

[iti-attunity-sup]

Hello Suresh.

Thank you for your reply.

So you don't have concrete permission list for Source database and Landing zone ?

Best Regards.

[sureshkumar]

Hello @iti-attunity-sup 

I would suggest try giving permission as mentioned in the user guide, if you face any issue please let us know.

Regards,

Suresh