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?