Grant Select Error while executing SAP Hana Views

[Former Member]

Hi,

While activating Attribute view or Analytical view iam getting the

"Grant Select privileges on schemas of the used data foundation tables to user "_sys_repo".

I have all the required privileges .Pls suggest.

Thanks in advance.

Phani Rayasam

[Former Member · Accepted solution]

Hi ,

The issue has been resolved by myself as i understood that i need to Grant Select Privileges on Schema of the Used one i.e My Schema to User "_Sys_repo" as below.

GRANT SELECT ON SCHEMA <schema Name> TO "_SYS_REPO";

Best,

Phani Rayasam

[Former Member · Accepted solution]

Hi,

Even we are facing the same issue.  But while executing the sql statement: GRANT SELECT ON SCHEMA <schema Name> TO "_SYS_REPO";, we get authorization issue.

FYI:

Could not execute 'GRANT SELECT ON SCHEMA SAPBHP TO "_SYS_REPO"' in 5 ms 905 µs .

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Kindly suggest how can we resolve this.

Also, could you please suggest what are all the required privileges/roles we need to provide to overcome such authorization errors?(Read roles/privileges)

Regards,

Antony Jerald.

[Former Member]

HI Phani,

As clearly mentioned in error , you missed to give grant permission to one of the tables that you are currently using in creating views. Please make sure whatever tables you are using in data foundation are from those schemas for which you have access...

You have to provide grant permission for that schema to your userid:

for e.g-  grant select on schema "ABC" to "MYID" with grant option.

grant execute on schema "ABC" to "MYID" with grant option.

Hope this helps!!!

Thnkss

Kulwinder