cancel
Showing results for 
Search instead for 
Did you mean: 

Do I need SELECT WITH GRANT OPTION in HDBGRANTS file?

analytics
Advisor
Advisor
0 Kudos

I have created a user provided service through CLI cups in order to access an existing calc views in _SYS_BIC. however the HANA academy says in .hdbgrants it needs to grant the technical user SELECT WITH GRANT OPTION. I am able to grant SELECT to the technical user, but there is no possibility to give GRANT OPTIOIN (radio button is grey out). Will this cause any potential trouble? I am now able to see the data through a synonym.

Thanks!

Accepted Solutions (0)

Answers (1)

Answers (1)

analytics
Advisor
Advisor
0 Kudos

if you remove the GRANT option from the container owner, then the container can’t grant access to other containers in cross container consumption activities.