on 01-23-2015 10:22 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.