cancel
Showing results for 
Search instead for 
Did you mean: 

Create a view - open data - insufficient privileges

08-28-2023 6:24 PM
alixpel Advisor
836 views 2 comments Go to solution
0 Likes
SAP Managed Tags
Subscribe

Tutorials: https://developers.sap.com/tutorials/hana-cloud-access-cross-container-schema.html
--------------------------

At Step 6 Create a view - Open Data, I get the following error in a pop up window :

Could not open 'DM_HDI_DB_1'.'RegionTextsView'.

Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid 'DF22148E4BA0DF44A6F541A3C8FF7A68'

The data preview uses the following statement to fetch data:

SELECT TOP 1000

"REGION",

"DESCRIPTION"

FROM "DM_HDI_DB_1"."RegionTextsView"

0 Likes

Accepted Solutions (1)

Accepted Solutions (1)

thomas_jung
Developer Advocate
Developer Advocate
0 Likes

It looks like you are using the wrong database connection to test the view. I can tell because I see Schemas as a node in the tree. Don't use a general DB connection but the container specific connection. Only the container technical user is going to have rights to access this view.

Answers (1)

Answers (1)

alixpel
Advisor
Advisor
0 Likes

Oh right !

Thank you Thomas.