cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with database-Studio

Former Member
0 Kudos

Hello

We use MaxDB for our SAP Systems and for our own applications(none SAP)

We upgradet our none-SAP Database from 7.7 to 7.8.02.21.

Then we tried the new Database Studio.

With problems!?

We have a schema BWALLE and a user BWPROGI.

When connecting to the database with SQL-Studio as BWPROGI we can see the schema BWALLE and all our tables.

When connecting to the database with Database Studio as BWPROGI we can't see the schema BWALLE and we can't see our tables??!!

We see 2 users BWPROGI and DBABW(the administrator).

Under BWPROGI there are no schemas!??

Under DBABW there are schemas(dbabw,domain,sysinfo) and all the tables/views belonging to these schemas.

What do we miss???

Why can we access our tables/views/indexes with SQL-Studio and not with Database-Studio.

Any help welcomed

Regards

Albert

Edited by: Albert Beermann on Nov 23, 2011 10:45 AM

Some more informations:

We have a group BWALLE nouser BWALLE.

The owner of the Schema BWALLE is the group.

The user BWPROGI is member of the Group BWALLE.

When connecting with SQL Studio as BWPROGI we see the schema BWALLE and all tables in the schema.

When connecting with MAXDB Maestro as BWPROGI we see the schema BWALLE and all tables.

When connecting with Database Studio as BWPROGI we can't see the schema BWALLE and don't see any table.

Connecting with SQL-Studio as BWPROGI shows the tables in schema BWALLE and we can read,update,... the data,

but with MAXDB 7.8 we get an error when doubleclicking on a table to look at the table structure.

With MAXDB Maestro everything works as expected.

??????

Regards

Albert

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188883
Active Contributor
0 Kudos

Hi Albert,

It is just a thought.

Can you add user BWPROGI to SAPDB administrator group and then check the results.

Regards,

Deepak Kori

Former Member
0 Kudos

Hello

How to do this???

Alter user BWPROGI DBA??

BWPROGI is member of group BWALLE and for group members i can only set mode resource or standard!

Or do you mean something else?

Regards

Albert