SQL Editor is only available for SQL User in MAXDB Database Studio

m_keijzer — Wed, 09 Jun 2021 11:09:37 GMT

Just installed MAXDB for a contentserver.

In MAXDB Database Studio I am not able to use the SQL Editor.

User SUPERDBA

Error Editor is only available for SQL User

Caused by: com.sap.dbtech.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [-4008]: Unknown user name/password combination

But I do know the right password.

[Local]:SOD>user_get superdba SERVERRIGHTS=UserMgm,InstallMgm,SystemCmd,DBFileRead,AccessUtility,Recovery,Backup,ParamFull,ParamCheckWrite,ParamRead,AccessSQL,ExecLoad,LoadSysTab,DBStop,DBStart,DBInfoRead,SharedMemoryMgm,SchedulerMgm,Scheduling,EvtDispMgm,EvtDisp,AccessCompleteSQL

GUIRIGHTS=

SECONDPASSWORD=NO

DISABLED=NO

COMMENT=

USERTYPE=DBA

EXTERNAL_IDS= PASSWORD_LIFETIME=ENABLED

MASTER_PW_ALTER_TIME=2021-02-02 23:47:11

MASTER_PW_EXPIRE_TIME=NEVER

Also tried [Local]:SOD>user_create sqluser,Maxdb superdba

this user is also not able to use the SQL Editor in MAXDB Database Studio.

Re: SQL Editor is only available for SQL User in MAXDB Database Studio

S_Sriram — Wed, 09 Jun 2021 11:34:34 GMT

Hi Keijzer

Refer to the SAP note 39439

Regards

Question Re: SQL Editor is only available for SQL User in MAXDB Database Studio in Technology Q&A

SQL Editor is only available for SQL User in MAXDB Database Studio

Re: SQL Editor is only available for SQL User in MAXDB Database Studio