I try to add a bind plan to my DB2 program with some owner name, after the addition I got the sql code error -551. Explain for the above error is
“-551 auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name “
From the above statement I understand that my owner (auth id) does not have access for the table which I have used in my program. My question is how to find the owner (auth id) which has the access for a particular table.
I believe some SYSIBM table might have the entry for the table, its owner and it's access type. Can anyone let me know what that table is?
why don' t You speak with the dba's
if the table was built by a different user maybe it was an oversight,
or anyway there are some authorization conflicts, and the dba' s will
need to know about it to fix it