Schema Mapping in .hdbrole in HANA 2.0

[former_member385194]

Hello,

we have different schemas in our S/4HANA landscape.

System a) 'SAP_DEV', system b) 'SAP_PRD'

They are mapped to Authoring Schema 'SAP_ECC'

How can I create design-time roles using this schema mapping to make use of transport functionality for a role that looks like that:

role mycompany.common.security::MYROLE
{
catalog sql object "SAP_ECC"."ACDOCA": //Objecttype: TABLE
SELECT;
}

Regards

Bastian

[former_member385194]

Hey gregorw can you have a look at this?

Have you found a solution for this problem? Looks similar to your problem

Best Regards

Bastian

[gregorw]

Hi Bastian,

great to hear from you hear in the SAP Community. The first question for me would be why would you need to access the HANA DB below the S/4HANA system. With CDS Views, ABAP Managed Database Procedures (AMDB) it should not be needed to develop on HANA native. Also I think that the runtime license of HANA for S/4HANA doesn't allow that usage.

Best regards
Gregor