could not activate views, authorisation Repo.modify_change

[Former Member]

Hi,

I have created a new schema under the name "3" and created two tables. Moving to content folder I created a new sub package named "3" under my native package that I was already working for another purpose.  I created a attribute view ,but it didn't get activated. it shows the error log as follows,

Could someone help me on this. Thank you.

[Former Member]

Try to execute the below command.

GRANT SELECT ON SCHEMA<SCHEMA WHERE TABLES RESIDE> TO _SYS_REPO

[Former Member]

I tried this, but the error still persist.

[varma_narayana]

Hi Rahul,

As per the original error that you have got while activating the attribute view, you need to have the "System privilege": REPO.MODIFY_CHANGE assigned for your user ID.

You cannot assign it to yourself. Hence request your security admin to assign this privilege to your user ID.

regards,

Narayana Varma

[Former Member]

so, it is like even for my own ID i should request for privilege from the security admin .

thanks a lot !!!

[Former Member]

Please give the privilege to the user. You can try after assigning REPO.MODIFY_CHANGE in system privilege tab for the specified user.

[Former Member]

when i do so it says,

how should I move further?

[Former Member]

Hi Rahul,

I think you are running the command with the same user, who's lacking the privilege.

If so, please use a different user with SYS_REPO privilege.

You can also use stored procedure as mentioned in the help link earlier.

Regards

Prithviraj

[Former Member]

I dint get you. how can I use a different user with SYS_REPO privilege. could you explain me in detail.

Thanks,

[Former Member]

Hi,

Check this blog,

Regards

Prithviraj

[Former Member]

Hi,

Go through below help link

Granting and Revoking Privileges on Activated Repository Objects - SAP HANA Security Guide - SAP Lib...

Regards

Prithviraj