Authorization problem SQL0551N

[Former Member]

Dear Experts,

I have installed SAP Solution Manager 7.1 SPS03 on AIX 6.1 & DB2 9.7 FP4. I get the following message in SM21:

"SQL0551N "SAP<SID>" does not have the required a or privilege to perform operation "EXECUTE" on "SYSPROC.MON_GET_TABLESPACE". SQLSTATE=42501 for user SAPSYS. I also get the following messages in DBACOCKPIT:

"Administration user data not set, database maintenance functions disabled", "No permission to maintain system. Reason: Wrong role for connection user SAP<SID>". I can use DBACOCKPIT partially cause I get more SQL0551N messages. It doesn't give me any dump.

I have already applied SAP Note 1456402 - DB6: DBA Cockpit Corrections for SAP Basis 7.02/7.30/7.31 and SAP Notes from SOLMAN_SETUP, any suggestion?

thanks in advance,

Ckawaii

Edited by: ckawaii on Jan 4, 2012 9:26 PM

Edited by: ckawaii on Jan 4, 2012 9:27 PM

[former_member189725 · Accepted solution]

Execute the grant statement

grant execute on function SYSPROC.MON_GET_TABLESPACE to SAP<SID>

then check if you get any more messages in SM21.

Also check if user SAP<SID> is assigned to OS group db<sid>mnt.

[Former Member]

solved: db2 grant DBADM on database to SAP<SID>

[stefan_ulrich2]

Hello,

this is not the best solution for the SAP Solution Manager 7.1

I have solve this with this command:

DB2 GRANT ROLE SAPTOOLS TO USER <CONNECT USER>

[former_member196032]

I do not have the role.

db2 "grant role saptools to user sap<sid>"

DB21034E  The command was processed as an SQL statement because it was not a

valid Command Line Processor command.  During SQL processing it returned:

SQL0204N  "SAPTOOLS" is an undefined name.  SQLSTATE=42704