Problem with differences DBStudio vs. SQL_Studio

[Former Member]

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

[balazs_takacs]

Hello Albert,

can you send us the result of the following statements?

SELECT * FROM USERS

SELECT * FROM SCHEMAS

Regards Balázs

[Former Member]

Hello

[balazs_takacs]

I've discussed this behaviour with the Development.

Database Studio seams really to restrict functions of users belinging to one usergroup.

Via SQLCLI (and of course SQL Studio) you should still be able to see and create tables as a member of a usergroup with resource priviledge

http://maxdb.sap.com/doc/7_8/45/7d7a31f3dd1956e10000000a11466f/frameset.htm

... and I suppose you are able to run queries on the tables of schema BWALLE logged on as BWPROGI in SQL editor of Database Studio. At least I could in my DB.

This will be corrected.

Until than you should use SQL Studio and SQLCLI.

Regards Balázs

[JamesZ]

Dear Albert,

How did you run sql via database studio? All these tools should use the same API to query database, so the behavior should be the same

Best regards,
James

[Former Member]

Hello James

Schema AAA = BWALLE

USER BBB = bwprogi

With user bwprogii can only connect to the database.

I can select the user bwprogi

I can see the folders Roles,Schemas,Usergroups,Users

But klicking on Schemas doesn't offer anything so can can't select tables and do further stuff!

When i connect as DBA everything is Ok. I can select schemas(Domain,Indexes,...) and select the tables in the schemas and do further stuff.

See screenshot (the real user is bwprogi! In my mail i named him BBB)

Same user (bwprogi) with SQL_Studio

Same user with SQL Maestro looks like this: