cancel
Showing results for 
Search instead for 
Did you mean: 

sql_execute Create USER SAPR3 PASSWORD SAP DBA NOT EXCLUSIVE have error me

former_member324993
Active Contributor

Dear all,

We setup a content server base SAP MaxDB,But the system have not user: SAPR3,Now we used "dbmcli -d SDB -u dbamin,sapsap",Logon the maxdb,when we user"dbmcli> sql_execute Create USER SAPR3 PASSWORD SAP DBA NOT EXCLUSIVE ",Then the system have error message "-5001,Missing priviege:DBA".Who can help me?

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member276252
Discoverer
0 Kudos

Hello Bill,

how did you fix you problem ?

I'm using superdba and I have the same problem/symptom.

May be the output of the sql_execute select * from users means something to Natalia:

sql_execute select * from users

OK

END

'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20090810';'00144904';'20090810';'00144904';'20090810';'00144904';'ASS';'vsrvass';0;'NO';(null)

'SUPERDBA';'';'DBSERVICE';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20090810';'00144941';'20090810';'00144941';'20090810';'00144941';'ASS';'vsrvass';6;'YES';(null)

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20030305';'00165800';'20120907';'00221521';'20120910';'00123333';'ASS';'vsrvass';10;'NO';(null)

'SUPERDBA';'';'SAPASS';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20030305';'00165806';'20030305';'00165806';'20120907';'00221958';'ASS';'vsrvass';13;'NO';(null)

'SUPERDBA';'';'SAPR3SHD';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20090810';'00202312';'20090810';'00202312';'20090810';'00202312';'ASS';'vsrvass';34;'NO';(null)

'SUPERDBA';'';'SAPR3';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20120910';'00164032';'20120910';'00164032';'20120910';'00164032';'ASS';'vsrvass';63;'NO';(null)

Thank you so much for your help

Alfredo

former_member229109
Active Contributor
0 Kudos

Hello Alfredo,

according output of "select * from users" SQL statement you have database SYSDBA user SUPERDBA and database DBA user SAPR3.

Please create new thread and let us know what problem you have.

Please also post in new thread:

- database version

- with what user did you connect to the database to run SQL statement

- what SQL statement you run

- what error did you get

Regards, Natalia Khlopina

former_member229109
Active Contributor
0 Kudos

HELLO,

Could you please run:

"dbmcli -d SDB -u dbamin,sapsap",

Logon the maxdb,then

dbmcli on SDB> sql_execute select * from users

and post the output.

What is the version of your database?

Regards, Natalia Khlopina

lbreddemann
Active Contributor
0 Kudos

Hi there,

you don't need to have a SYSDBA user here - but a user that actually is DBA.

Anyhow, since you're using DBADMIN it looks as if you've tried to manually create a MaxDB Instance and now want to create the SAPR3 schema user.

Don't do this!

Please use sapinst for this.

As you're instance doesn't seem to have any data in it yet, the quickest way to get out of this situation will be to drop the current instance and to re-do the whole setup just as it is described in the installation/system copy guide.

Manually creating a target instance for a content server is of course possible, but you have to know the details!

regards,

Lars

Former Member
0 Kudos

Hello Bill,

the syntax of your SQL statement seems correct.

Even though you are connected as DBADMIN, it seems that the connected user lacks the correct privilege:

-5001 The user is not authorized to execute the SQL statement.

Regards,

Mark

former_member324993
Active Contributor
0 Kudos

Hi Mark,

I know The user is not authorized to execute the SQL statement,How to get the user the authorized.

Former Member
0 Kudos

Hello Bill,

SAP note 25591 is the best guess that I have. If you know that user DBADMIN isn't your user with SYSDBA-privileges, then maybe the default user name is correct and SUPERDBA is the user with SYSDBA-privileges. Unlike with Oracle you are in deep trouble if you don't know the password of your SYSDBA user on MaxDB.

Cheers,

Mark

former_member324993
Active Contributor
0 Kudos

Thank you mark,I will try it.