Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

run native sql commands on objects in different database schema

Our database is divided into two schemas: PSAPVR3 and VERTEX. One of our developers is trying to run native SQL statements on objects in the VERTEX schema. When he runs this he receives the short dump DBIF_DSQL2_OBJ_UNKNOWN. We're assuming this is because the OPS$DR1ADM which owns the PSAPVR3 schema doesn't have permissions to perform operations on the VERTEX schema objects (the lack of permissions has been confirmed). We've come up with two options but are not sure which would be the SAP preferred method.

1. Give OPS$DR1ADM permissions to perform needed SQL statments on VERTEX schema objects.

2. Add an entry to the DBCON table. Does this work as usual since we are not trying to access an external database?

Not what you were looking for? View more on this topic or Ask a question