on 08-24-2012 7:58 AM
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
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.