Skip to Content

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

Problem with differences DBStudio vs. SQL_Studio

Hello Everybody

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.

Best regards

Albert

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