on 11-04-2018 6:47 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.