Granting schema privileges

[Former Member]

HI,

How to grant privileges on SLT derived schemas in HANA.  I am getting insufficient authorization when I try to give the command grant select on schema <schema_name> to <user/role> with grant option;

Ganga

[Former Member]

Hi Patnaik,

There are SLT roles pre-created for the target schema configured as

<target_schema>_DATA_PROV → Role to manage data provisioning

<target_schema>_POWER_USER → Contains all SQL privileges of the target schema

<target_schema>_USER_ADMIN → Role to execute authority procedures

The user used to configure the target schema, gets the roles and can be us dto grant other users these respective roles.

Regards,

Anjali.

[former_member182302]

Hi There,

For your user ask the basis to assign the below role:

<SLT_SCHEMA>_DATA_PROV

Regards,

Krishna Tangudu

[Former Member]

Hi Krishna,

I tried it but same error again. It didn't worked.

Regards,

Ganga

[former_member182302]

Did your basis assigned that role and still you are not authorized on STL schema?