If tables of a schema are used to build modeling views then it’s necessary to grant select privilege to user _sys_repo. Why?
Answer Posted / Pushpendra Kumar
_SYS_REPO is the system repository for SAP HANA, where all the metadata and objects are stored. When you create modeling views using tables from a schema, SAP HANA generates internal objects in the system repository to represent these views. Granting SELECT privilege to _SYS_REPO user ensures that your application can access these generated objects.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category