Not able to execute table with new user created

[former_member226419]

Hi,

I have created a new user TEST from existing hana user 'HANA'.

I am having two queries.

a.) I cannot see all schema names which are there in HANA.( existing user. )

b.) Secondly my main motive is to execute one calculation view under package 'HANA' with newly user ID 'TEST'.

     I can see all the packages are there in user ID TEST but when i am trying to execute that calculation view it says

     insufficient privilege for executing a 'SALES_TABLE' ( included in existing calculation view).

How can I give privilege to execute this table?

BR

Sumeet

[lbreddemann]

Please make yourself familiar with the privilege management concept in SAP HANA and analytic privileges.

The questions you have can be answered by reading the documentation - so that's what I propose you do.

- Lars

[former_member226419]

Hi lars,

I am applying analytical privilege only. but only thing is I am not able to give execute privilege to other user.

Will this be given by user admin only since I am not an admin. I am using remote HANA system for practicing ? Rest all the steps I am done with. To below schema I want to grant execute privilege to all tables and schemas which I am not able to do.

BR

Sumeet