B
Bill Wood
Guest
The short answer is YES. Data Access via SQL (both ODBC and JDBC) follow the ‘visibility’ rules for the owner of the connection. There is more on this in the documentation: Look at the book on “OpenEdge Data Management: SQL Development” at http://documentation.progress.com/output/OpenEdge114/pdfs/dmsdv/dmsdv.pdf See Chapter 6: Using Data Manipulation Language statements Under SELECT. There are examples that include doing joins across tables with multi-tenancy and how to do this as a DBA or super-tenant. But generally, to get the data for a single tenant you just run the SQL statement with a user from that tenant.
Continue reading...
Continue reading...