cancel
Showing results for 
Search instead for 
Did you mean: 

provide access to view

former_member207019
Participant
0 Kudos

Dear All,

I am using HANA as a secondary data base. I have replicated the required tables to HANA and i have created view on HANA DB similar to ECC system.

Now when i am trying to access the HANA transaction code from ECC system to HANA as a secondary data base, It is telling "insufficient privilege: Not authorized:"

I  have tried with below statment... I am not sure how to give access to HANA view from ECC system.

SELECT ON view V_GLPOS_C_CT TO _SYS_REPO WITH GRANT OPTION;

Regards,

Jo

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Jyotsna,

Try executing below statement.

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO _SYS_REPO WITH GRANT OPTION;


Replace <YOUR_SCHEMA> with schema name where your tables are present.



former_member210482
Active Participant
0 Kudos

Hi Jo,

can you elaborate "Now when i am trying to access the HANA transaction code from ECC system to HANA as a secondary data base"

Regards,

Safiyu

former_member207019
Participant
0 Kudos

I am trying to access FBL3H tcode which would pull the data from HANA(which is secondary DB) instead of ECC on Oracle.

So required tables and views have been created on HANA.

But when i tried to run this tcode, it is restricting me due to view acess right is not available.