Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Could not execute 'grant select on schema to _SYS_REPO with grant option'

Hi,

I have created a new schema in HANA development perspective with the name as SCHEMA991.hdbschema.

I then tried to grant select privileges to the owner of the new schema by the following command --

      call _SYS_REPO.GRANT_SCHEMA_PRIVILEGE_ON_ACTIVATED_CONTENT('select','SCHEMA991','HANAUSER');

-- where "HANAUSER" is the HANA studio userid.

I am also tried the below command, but I m getting the same error -

          grant select on schema <schema> to _SYS_REPO with grant option;

But When I create schema from modeler perspective and run the below command, it runs perfectly.

          grant select on schema <schema> to _SYS_REPO with grant option;

Please provide your valuable  inputs to solve this problem. PFA

HANAERROR2.png (73583 B)
Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question