Can you run a SQL statemant on one tenant for a database that is conected with ODBC ?
Can you run a SQL statemant on multiple tenant for a database that is conected with ODBC ?
In a multi tenant database, users belong to tenants. tenants have one or more "domains" that are used to specify how user identity is authenticated. when a user logs in, they log in with a user name and a domain name. e.g. bob@progress or bob@cisco. this establishes the user's user id id and tenant id. the tenant id is used by the database to determine what data to return for queries. this is so for SQL connection as well as 4GL connections.
if a user belongs to a "supertenant" domain then they can read data (via SQL or 4GL) belonging to any tenant (provided the normal access privileges allow).