TDF IMPLEMENTATION- step map your scheme

[bastorino72]

Dear all

I'm following the step of this official link

https://help.sap.com/viewer/7ea3b5ee749543f7be1cc778c8caa72f/1.0.16/en-US/ba6e5b07707e4583b441d65c28...

after the installation of ADD ON and its patches I do have to give these grants:

1. grant select on schema <your S/4HANA schema> to <your system user> with grant option.

2. grant execute on schema <your S/4HANA schema> to <your system user> with grant option.

3. grant select on schema <your S/4HANA schema> to _SYS_REPO with grant option.

4. grant execute on schema <your S/4HANA schema> to _SYS_REPO with grant option.

5. grant select on schema <your replicated ECC schema> to <your TDF schema> with grant option.

I suppose to give them in SAP S4 (not the TDF system). is it my assumprtion correct?

if correct I do have to create the statements this way.

SAP S4 SCHEME NAME SAPHANADB

1. grant select on schema SAPHANADB to <your system user> with grant option.

2. grant execute on schema SAPHANADB to <your system user> with grant option.

3. grant select on schema SAPHANADB to _SYS_REPO with grant option.

4. grant execute on schema SAPHANADB to _SYS_REPO with grant option.

5. grant select on schema <your replicated ECC schema> to <your TDF schema> with grant option

the other dubt are:

what is the <your system user> and <your replicated ECC schema> and <your TDF schema>?

where I can find them?

thank you

Bruno

[bastorino72]

really no one had performed this step?

[fedaros]

Hi Bruno,

"I suppose to give them in SAP S4 (not the TDF system). is it my assumption correct?"

NO. On scenario pointed on help sap you choose, the system is replicated from S/4 to a different system using SLT, so your TDF will not have access to S/4, but the data replicated to the same HANA database together with TDF schema.

Related to this scenario, you will have a schema with S/4 data (replicated by SLT) and another schema with Netweaver data of TDF installation.

TDF views need to access both schemas an the grant is to you provide access to _SYS_REPO runs it.

In this case your s/4hanaschema and your replicated ecc schema are the same. Normally we create user/schema of replication with something pointing to source, like DEV200 for development system.

grant select on schema DEV200 to _SYS_REPO with grant option;

grant execute on schema DEV200 to _SYS_REPO with grant option;

Steps 1, 2 and 5 are helpful to grant access for future investigation of system user or by the netweaver TDF owner but are not mandatory.

Regards, Fernando Da Rós

Observação: Repassei informações sobre esta documentação para análise do time de desenvolvimento.