System view not showing data in Container

[Ajinkya_Jadhav]

Hello, 
When we are trying to access the system view (for example, _SYS_TASK. START_TASK_MESSAGES) as a synonym in the container project, it executes without any error but shows no data. 

Same view when accessed from the database SQL console using db user, it shows the data.

Is there any workaround we have to do to make this data visible from container?

Steps to replicate the issue. 

1. Create a synonym on top of SYS_TASK.START_TASK_MESSAGES. 
2. Do data preview on the synonym using the container sql console(RT user).  [Data will be not visible]
3. Do SELECT * FROM _SYS_TASK.START_MESSAGES using your DB user [You will see the data].

System views which are having same issues are as follows.

1.     SYS.M_TASKS
2.     SYS.M_TABLE_STATISTICS
3.     _SYS_TASK.START_TASK_MESSAGES
4.     SYS. USER_PARAMETERS

Does anyone faced the same issue? Is there any workaround for this?

Thank you in advance.

Best Regards,

Ajinkya Jadhav

[Cocquerel · Accepted solution]

Most of system views have some logic to filter the data depending on user system privileges. As you can see in the screenshot, M_TABLE_STATISTICS will return no result if you don't have system privilege CATALOG READ or DATA ADMIN.

When running a data preview in BAS or WebIDE for HANA, the query will execute with the application user  of your hdi container (user ..._RT). To grant necessary privilege to application user, you should use .hdbgrants artifact (see https://help.sap.com/docs/SAP_HANA_PLATFORM/4505d0bdaf4948449b7f7379d24d0f0d/f49c1f5c72ee453788bf79f... )

[HakanHaslaman]

The problem may be due to user permissions in the container. Ensure the user has the required SELECT privileges on system views. If not, grant them using the GRANT statement, e.g., GRANT SELECT ON _SYS_TASK.START_TASK_MESSAGES TO <user>. Retry accessing system views. If the issue continues, contact SAP Support as it may be a SAP HANA bug.