SQLCODE -551

Document ID : KB000097562
Last Modified Date : 22/05/2018
Show Technical Document Details
Issue:
User received the following error message upon invoking the XP  Execution Procedures from the PDA  Main Menu:
********************************* TOP OF DATA *********************************
DSNT408I SQLCODE = -551, ERROR: DBPSTS2 DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION SELECT ON OBJECT PTI.RAEP_PROC_1105 DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE DSNT415I SQLERRP = DSNXOSC SQL PROCEDURE DETECTING ERROR DSNT416I SQLERRD = -10 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION DSNT416I SQLERRD = X'FFFFFFF6' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
******************************** BOTTOM OF DATA *******************************
Userid DBPSTS2 is the package owner of all the CA packages. What other authorizations that are needed for PDA? 
Resolution:
1- Either grant userid DBPSTS2 SELECT, Update, Delete and Insert to PTI.RAEP_PROC_1105 and all the PDA tables which you can find in CDBASKL0(PDADDL) or
2-Make sure that userid DBPSTS2 has autorization to the PDA PLANS. which can  be done thru Product Authorization option which option A under General Facilities (_ A Product Authorizations)