How to create "SQL user"?

467 Views

I'm trying to use MaxDB Database Studio (7.7, db 7.7) to manage tables on the system. However, the existing DB accounts are only SUPERDBA and CONTROL, and with both MaxDB Database Studio only tells me that DBM sessions are possible. For SUPERDBA I don't have password so I used the CONTROL user to copy the account to a new one.

What I get is the following:

SERVERRIGHTS=DBInfoRead,SystemCmd,ExecLoad,UserMgm,DBFileRead,Backup,InstallMgm,LoadSysTab,ParamCheckWrite,ParamFull,ParamRead,DBStart,DBStop,Recovery,AccessSQL,AccessUtility,SharedMemoryMgm,SchedulerMgm,Scheduling,EvtDispMgm,EvtDisp

GUIRIGHTS=

SECONDPASSWORD=NO

DISABLED=NO

COMMENT=

USERTYPE=

I know I probably need USERTYPE=SAP or USERTYPE=DBA but after spending many hours search documentation its nowhere to find

Pls help

Sanjay