cancel
Showing results for 
Search instead for 
Did you mean: 

Could not execute 'GRANT SELECT ON SCHEMA' - insufficient privilege: Not authorized

Former Member


Hi,

I am following some instructions from within an SAP PDF which has instructed me to create a SCHEMA called SENTIMENT_REPLICATION.

It then instructs me to "SELECT ON SCHEMA "SENTIMENT_REPLICATION" TO _SYS_REPO WITH GRANT OPTION;" - but this will not work for me.

I am logged onto the HANA DB as SYSTEM, but I keep getting insufficient privilege: Not authorized messages.

I have attached 2 screen shots as perhaps I am not doing this correctly.

I also tried opening up the _SYS_REPO schema, and adding the SENTIMENT_REPLICATION with SELECT permissions, but I get the same error.

I am runnnig the 64-bit client, Version 1.0.32 (Build 201206211814 - 363548).

I have HANA running on an AWS instance.

Any help would be greatly appreciated.

Thanks,

Anton

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

ok... after much hair pulling and struggling - the issue has been resolved by:

1 - Logging into HANA as the SENTIMENT_REPLICATION schema

2 - running the GRANT statement

I was under the impression that the SYSTEM schema would have the neccessary ability and permissions to perform my above issue, but this is clearly not the case...

Former Member
0 Kudos

Hi

Iam also facing same issue could you please let me know how to resolved