cancel
Showing results for 
Search instead for 
Did you mean: 

MaxDB / SQL studio - command question..

Former Member
0 Kudos

Hello,

I have MaxDB7.6 installed in my system(winxP prof) during NW2004s ABAP installation.

I tried to connect in command line using 'superdba' and 'control', it connects.

dbmcli - d NSP -u superdba,admin

dbmcli - d NSP -u control,admin

At the same time, when I connect to SQL studio using

'control' user(admin is password), it fails with below error message.

Invalid authorization specification, -4008 POS(1) Unknown username/password combination return code :SQL ERROR (-4008)

But, it connects to SQL studio successfully using 'superdba' login id.

Could any body please throw some light on this..

thanks,

partha

Accepted Solutions (0)

Answers (1)

Answers (1)

roland_mallmann
Advisor
Advisor
0 Kudos

Hi,

one difference (there are more differences!) between the 'control' and 'superdba' user is that one is a non-sql user (control) and the other a sql user (superdba).

The control user is the standard name for the DBM user, whereas 'superdba' is the standard name for the SYSDBA user.

More on this can be found in the documentation:

http://dev.mysql.com/doc/maxdb/en/default.htm

-> Basic information

-> Concepts of the Database System

-> Glossary

-> User

Regards,

Roland

Former Member
0 Kudos

Thanks Roland. It makes sense now for me.

I guess, I need to come out of oracle for the time-being..

thanks,

partha

Former Member
0 Kudos

If i connect as SUPERDBA, should i be able to see the SAP tables, such as what i can see via SE16?

Cheers

roland_mallmann
Advisor
Advisor
0 Kudos

Hi Matthew,

no, if you want to see the SAP tables, you'd need to logon with the relevant SAP user, i.e. SAPR3 or SAP<SID>.

Regards,

Roland

Former Member
0 Kudos

Hi Roland,

In my case i can't login the MaxDB to see the SAP tables by user:sap<sid>,how about u?

I just view last url content,and login with user:sap<sid>db,for my case it is:sapbeedb(my sid is "bee")

https://help.sap.com/saphelp_nw04s/helpdata/en/ca/69d8b637f1bb4d913c877c1ab33b73/content.htm

best regard

reefish

roland_mallmann
Advisor
Advisor
0 Kudos

Hi,

the user SAP<SID>DB is the owner of the J2EE instance tables. SAPR3 or SAP<SID> are non-J2EE related.

Regards,

Roland