I believe this is a general problem in the Db2 on Cloud Free Plan. You can't grant exeute to yourself and has nothing to do with DMC.
Original Message:
Sent: Wed July 24, 2024 05:24 PM
From: Jan Nelken
Subject: The statement falied because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
Error message says:
The statement falied because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
IF you executed Cynthia's script - you probably executed this:
GRANT EXECUTE ON FUNCTION SYSPROC.* to user FKT49670;
GRANT EXECUTE ON PROCEDURE SYSPROC.* to user FKT49670;
To which userid you wanted to grant EXECUTE and with which userid you are connecting to monitored database?
------------------------------
Jan Nelken
Original Message:
Sent: Wed July 24, 2024 05:05 PM
From: Manuel Semente
Subject: The statement falied because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
thanks cintia, but this comands dosent work, i got u.
and i use the free account and i cant talk with the support
------------------------------
Manuel Semente
Original Message:
Sent: Mon July 22, 2024 03:08 PM
From: Cintia Ogura
Subject: The statement falied because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
Hello Manuel,
Did you run the following commands on the monitored database:
GRANT EXECUTE ON FUNCTION SYSPROC.* to user FKT49670;
GRANT EXECUTE ON PROCEDURE SYSPROC.* to user FKT49670;
If you did and you still have a problem, please create a case so we can investigate the issue.
Thanks, Cintia.
------------------------------
Cintia Ogura
Original Message:
Sent: Sat July 20, 2024 06:14 PM
From: Manuel Semente
Subject: The statement falied because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
hey i have the same problem an i problem and i put your script but dont solve.
u can explain me what reaaly happen or help me to found the right soluction?
see:
The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "FKT49670". Operation: "EXECUTE". Object: "SYSPROC.MON_GET_CONTAINER"..
------------------------------
Manuel Semente
Original Message:
Sent: Tue July 09, 2024 09:35 AM
From: Cintia Ogura
Subject: The statement falied because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
Hello Rajeswar,
It looks like your user DM447I4 does not have the EXECUTE privileges for the SYSPROC routines.
The recommendation would be the same for as for DMC standalone version:
https://www.ibm.com/docs/en/db2-data-mgr-console/3.1.x?topic=console-min-db-privileges-required-db2
GRANT EXECUTE ON FUNCTION SYSPROC.* to user <userid>;GRANT EXECUTE ON PROCEDURE SYSPROC.* to user <userid>;
I hope that helps!
------------------------------
Cintia Ogura
Original Message:
Sent: Mon July 08, 2024 10:34 PM
From: RAJESWAR S S
Subject: The statement falied because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
HOW YO SOLVE MY ERROR IN IBM DB2 CLOUD, ANY ONE HELP TO SOLVE THIS ISSUE. DOESN'T VIEW TABLES.
The statement failed because the authorization ID does not have the required Authorization or privilege to perform the operation.Authorizatiom ID :"DM447I4", Operation: "EXECUTE". Object: "SYSPROC.MON DET CONTAINER"
------------------------------
RAJESWAR S S
------------------------------