Skip to Content
-1
Jul 21, 2018 at 02:31 PM

invalid table name: Could not find table/view SUPERSTORE in schema PAL

2629 Views

Hi,

im trying to create a new view with my User "DEVUSER" on my Schema "PAL" and the tabel "Superstore". I wrote a small SQL Statement

CREATE VIEW V_KNN_SS_DATA AS

SELECT ID, Region, Category, Sales, Quantity

FROM PAL.Superstore;

But I get an error, that it couldnt find the table.

First I thought it could be a missing privilege on the schema, but I checked my DEVUSER and it has all privileges on the "PAL" Schema

Looking forward to your answers :)

Attachments

bild2saphelp.png (77.8 kB)
bild3saphelp.png (70.0 kB)
bild1saphelp.png (149.9 kB)