default password for <SID>adm

[Former Member]

The subject says it all - I am new to MaxDB, and did not install the application.

We are trying to update some tables, and get permission errors.

I have the SUPERDBA user, but that user does not have permissions on the <SID>ADM tables.

Is there a default password for the <SID>ADM database user?

I am probably missing something very easy here.

[Former Member · Accepted solution]

Thank you again for your help/patience

I have no idea what the SAPGRDDB password is - and the person who installed it claims he was never prompted, and "sap" does not work - I guess I have to reset the password.

I CAN connect as SUPERDBA, but that doesn't seem to get me anywhere, b/c SUPERDBA can't query those tables either. I guess there is no user that is like the SQL Server "sa" user or the Oracle "System" user that can query any table?

Thanks,

Sean

[former_member229109 · Accepted solution]

Hello,

-> I asked you if you CAN connect as SUPERDBA => check if the password of superdba user is working as password of SAPGRDDB user.

You could not access the application tables ownered by SAP<SID> or

SAP<SID>DB as SUPERDBA user.

-> Please review the SAP note, if you need to reset the password of DBA user:

25591 Changing the DBM, SYSDBA and DBA user passwords

Thank you & best regards, Natalia Khlopina

[former_member229109]

Hello Sean,

-> Are you SAP customer?

-> Please review the MAXDB library at

http://maxdb.sap.com/doc/7_7/default.htm -> Database Administration

-> Managing Users

You will see the "SAP Standard Users for Databases" & "SAP MaxDB Standard Users", the <SID>ADM database user is NOT listed as standard.

-> Please connect to the database as superdba user, run the SQL statements

'select * from users'

'select * from tables where tablename = '<TABLE-NAME>'

and post the outputs.

Thank you and best regards, Natalia Khlopina

[Former Member]

SAP customer - yes - I am reviewing the documentation - it leaves a lot to be desired

Here is the output you requested:

dbmcli on GRD>sql_execute select * from users

OK

END

'CONTROL';'';'CONTROL';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20090218';'00160032';'20090218';'00160032';'20090218';'00160032';'GRD';'grc-app-dev01';0;'NO';(null)

'SUPERDBA';'';'SUPERDBA';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20090218';'00160032';'20090218';'00160033';'20090218';'00160032';'GRD';'grc-app-dev01';10;'NO';(null)

'SUPERDBA';'';'SAPGRD';'DBA';'MULTIPLE';(null);(null);(null);'UNICODE';'20090218';'00160045';'20090218';'00160045';'20090218';'00160045';'GRD';'grc-app-dev01';28;'NO';(null)

'SUPERDBA';'';'SAPGRDDB';'DBA';'MULTIPLE';(null);(null);(null);'UNICODE';'20090218';'00160052';'20090218';'00160052';'20090218';'00160052';'GRD';'grc-app-dev01';29;'NO';(null)

I'm not 100% sure what you are looking for on the second query, all I could get to work was this -

select * from tables

which gives a lot of output, here is some:

'SUPERDBA';'SUPERDBA';'ROOTS';'SEL+';'SYSTEM';'VIEW';'20090218';'00160033';(null);(null);(null);(null);(null);(null);(null);;x'00000000000000B1';(null);(null);(null);(null)

'SUPERDBA';'SUPERDBA';'RUNNING_COMMANDS';'SEL+';'SYSTEM';'VIEW';'20090218';'00160033';(null);(null);(null);(null);(null);(null);(null);;x'00000000000000B2';(null);(null);(null);(null)

'SUPERDBA';'SUPERDBA';'RUNNING_PARSEIDS';'SEL+';'SYSTEM';'VIEW';'20090218';'00160033';(null);(null);(null);(null);(null);(null);(null);;x'00000000000000B3';(null);(null);(null);(null)

'SUPERDBA';'SUPERDBA';'SERVERDBSTATISTICS';'SEL+';'SYSTEM';'VIEW';'20090218';'00160033';(null);(null);(null);(null);(null);(null);(null);;x'00000000000000A1';(null);(null);(null);(null)

[former_member229109]

Hello Sean,

-> You have the DBA database users SAPGRD & SAPGRDDB.

I could not see the <SID>DBM user in the database.

There is may be confusing with the OS user of the database server.

-> With the second statement I would like to see the owner of the database

table you are going to update.

-> The default password of the SAP<SID> user is sap.

-> Please let me know what table are you you planning to update?

With what user did you connect to the database to update the table?

-> Please review the SAP note:

25591 Changing the DBM, SYSDBA and DBA user passwords

Thank you & best regards, Natalia Khlopina

[Former Member]

Natalia - thank you for your help - I am an Oracle DBA, and I am new to MaxDB

-> With the second statement I would like to see the owner of the database

table you are going to update.

Here is the output of the second statement, I login as SUPERDBA

dbmcli on GRD>sql_execute select * from tables where tablename='VIRSA_CC_CONFIG'

OK

END

'SAPGRDDB';'SAPGRDDB';'VIRSA_CC_CONFIG';'SELUPDDELINSREFINDALT+';'TABLE';'TABLE';'20090219';'00164016';'20090219';'00164016';'20090219';'00164016';'NO';(null);20000;(null);x'000000000000B026';'NO';'NO';'YES';'NO'

[former_member229109]

Hello Sean,

-> The user SAPGRDDB is the owner of the database table 'VIRSA_CC_CONFIG' . You need to connect as SAPGRDDB user

to run the update of the table 'VIRSA_CC_CONFIG' .

-> Did you try to connect as user SAPGRDDB with default password sap?

Did you use default password to connect to the database as SUPERDBA user?

Thank you & best regards, Natalia Khlopina