How to grant access to tables created under different schema - Attribute Views on tables from different schemas

[Former Member]

Hi

I have created column based table under my user e.g. ATANA in HANA. There are few more tables replicated from H11_EB1 schema. When we are trying to create attribute view on top of tables from tables from different schema, then I am getting error whenever I am trying to access tables from ATANA schema.

Can you please let me know what is the process of granting access to ATANA schema to be used in views.

Thanks and Regards

anu

[rama_shankar3 · Accepted solution]

Anu,

You can also do this using the HANA studio graphical interface for the user manually. It is good to learn SQL in general though.

Regards,

Rama

[former_member42822 · Accepted solution]

Hi,

From the admin user, open the user and assign the schema and privileges and activate it.

refer the screenshot attached,

[Former Member · Accepted solution]

Thanks!!

[former_member184768]

Hi Anu,

Connect with the user having system privileges  and GRANT SELECT access on H11_EB1 schema objects to ATANA.

Please refer to 8.1 section in the security document http://help.sap.com/hana/hana_sec_en.pdf

Regards,

Ravi