SAP MDM on DB2 database

[former_member184628]

Hi All,

We are trying to install MDM with DB2 Database (10.1).

We are following the guide provided (https://websmp106.sap-ag.de/~sapidb/011000358700000059322011E)

Now while granting the privileges to the user db2mdm we are facing below issues.

Error:

C:\Windows\system32>db2 GRANT CONNECT, BINDADD, CREATETAB, IMPLICIT_SCHEMA, LOAD

, CREATE_EXTERNAL_ROUTINE ON DATABASE TO USER db2mdm

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

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

SQL0554N  An authorization ID cannot grant a privilege or authority to itself.

SQLSTATE=42502

I know that we cannot assign authorization to the same user which is executing the command, but the question is what is the way around as we have tried creating users and then trying to assign authorization via them but it is failing.

I am not sure how this is going to work when the document is asking to do the same.

db2 –tvf grant_revoke.sql

CONNECT TO MDM;

GRANT SELECT ON SYSIBM.SYSTABLES TO USER db2mdm ;

GRANT SELECT ON SYSIBM.SYSCOLUMNS TO USER db2mdm ;

GRANT SELECT ON SYSIBM.SYSINDEXES TO USER db2mdm ;

GRANT SELECT ON SYSIBM.SYSPLAN TO USER db2mdm ;

GRANT SELECT ON SYSIBM.SYSVIEWS TO USER db2mdm ;

GRANT UPDATE ON SYSCAT.INDEXES TO USER db2mdm ;

GRANT UPDATE ON SYSCAT.TABLES TO USER db2mdm ;

GRANT UPDATE ON SYSCAT.COLUMNS TO USER db2mdm ;

GRANT CONNECT, BINDADD, CREATETAB, IMPLICIT_SCHEMA, LOAD,

CREATE_EXTERNAL_ROUTINE ON DATABASE TO USER db2mdm ;

GRANT DBADM ON DATABASE TO USER db2mdm ;

Please suggest as I am sure many of you may have faced this issue.

Thanks,

Sharib Tasneem

[JPReyes]

Hi Sharib,

Have you tried to logon as a different user who belongs to the db2admns group and run the command again?

This should be very simple to fix.

Regards, Juan