Skip to Content
0

Not able to open data preview for any table in SAP_HANA_DEMO catalog object ?

Dec 21, 2016 at 07:54 AM

192

avatar image

I am a beginner in SAP HANA and doing self-learning and exploring things into it by getting help from communities and articles across the world over internet. There is this common error I have seen people discussing in community which I too had encountered:

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

while I tried to Open Data Preview of one of the table in SAP_HANA_DEMO catalog object while logged in as SYSTEM user on a SAP HCP trial instance ?

Below are few screen shots which may be helpful for you to understand what could possibly be going wrong:

My HANA Cloud system

I have seen in few post where people have discussed something related to screen below, please let me know is this rightly configured (it is default by the way):

Please guide me, where am I going wrong or how to overcome this error.

Thank You.

a1.png (17.4 kB)
a2.png (60.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Manjunath Baburao
Dec 21, 2016 at 11:58 AM
1

Hello Roshan,

Can you check if the user _SYS_REPO has SELECT rights on the schema/catalog object SAP_HANA_DEMO under Object Privileges.

Regards,

Manju

Show 3 Share
10 |10000 characters needed characters left characters exceeded

I have checked it, here is the screen (it is disabled).

below screen is for SAP_HANA_DEMO (it is enabled, but I cannot modify it as it throws error)

Could not modify user '_SYS_REPO'. Could not grant privilege SELECT on SAP_HANA_DEMO You are not authorized to perform the required actions

a3.png (67.8 kB)
a4.png (59.2 kB)
0

Hello Roshan,

Try to assign the role starting with 'sap.hana.democontent*' to your user (SYSTEM) and check again.

Regards,

Manju

1

It worked! Thank you very much sir. :)

0