Skip to Content
0
Sep 01, 2014 at 11:19 AM

Authorization issue in activating Attribute view using Tables from different schema

112 Views

Hi Experts,

I have create 1 Schema 'XYZ' in HANA and this contains some of the Tables i.e. MARA.

Now i have ran the below 2 statements to grant other users 'A' access to my Schema 'XYZ'.

GRANT SELECT ON SCHEMA XYZ TO A WITH GRANT OPTION;

GRANT EXECUTE ON SCHEMA XYZ TO A WITH GRANT OPTION;

But still the User 'A' is facing authorization while creating attribute views on Table MARA.

Please suggest.

thanks