Skip to Content

Do I need SELECT WITH GRANT OPTION in HDBGRANTS file?

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 19, 2017 at 12:10 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded