Problem with differences DBStudio vs. SQL_Studio
We use MaxDB for our SAP Systems and non-SAP Applications.
On one MAXDB Instance(7.8) we have a group AAA and a user BBB that belongs to that group.
The user BBB can create,alter,drop tables and of course insert,delete,...
Wenn looking at the tables(more than 500), the schema is AAA and the owner is AAA
All own applications connect with user BBB.
(the database administrator who build the database more than 10 years ago left the company!)
Everything works as expected.
With SQL-Studio(7.6) we can connect as user BBB, select the schema AAA, see all the tables and do anything we want.
With Maxdb Maestro(another MaxDb Gui) we can connect as user BBB, select the schema AAA, see all the tables and do anything we want.
But with the new DBStudio we only can connect? We can't select the Schema AAA and we don't see any table that belongs to that schema?
What do we miss? What is the difference between SQL-Studio and DBStudio?
We would pefer to use DBStudio in future.
Any help welcomed.