Skip to Content
avatar image
Former Member

Authorization issue in activating Attribute view using Tables from different schema

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 01, 2014 at 01:36 PM

    Hi,

    What is the exact issue/error?

    Best regards,

    Wenjun

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Lars Breddemann

      Hi Lars,

      Thanks for your inputs again.

      Need to clarify 1 thing.

      I created schema 'XYZ' and granted access to _SYS_REPO by running the above stated SQL

      So now how in future would access be granted to other users 'A' and 'B'.

      Once all the information models in my schema are activated and i ran the above SQL and grant access to _SYS_REPO then how _SYS_REPO would grant access to users lets say A as of now and later B,C ,D...... Is it by defalut that this would be granted.

      Please help me in understanding this.

      Appreciate all the help and support.