cancel
Showing results for 
Search instead for 
Did you mean: 

Accessing HANA Database custom schemas from AMDP procedure

naveenchepuri_en
Explorer
0 Kudos

Hello Team,

We are facing issue in accessing HANA Database custom schemas from AMDP procedure . This HANA is on MDC architecture.

System raising message “Insufficient privileges, Not authorized”.

I own the schema which I am trying to access, that comes default with user ID creation. We are facing this issue with all custom built schemas.

We tried with most of the possible roles and privileges but couldn’t overcome this issue. Can you please help in resolving the issue as its stopping a deliverable.

Schema has all privileges on assigned to _SYS_REPO and other required schemas.

we are not able to understand what is the missing link.

Accepted Solutions (1)

Accepted Solutions (1)

pfefferf
Active Contributor

The user which is used to establish the database connection needs the privileges to access the "custom schema(s)". That user is not _SYS_REPO and not your personal user. You can check which user is used in e.g. transaction DB02.

naveenchepuri_en
Explorer
0 Kudos

Thank you very much Florian Pfeffer. It worked :). You saved my weekend.



Answers (0)