| View previous topic :: View next topic |
| Author |
Message |
Kuldip
Beginner
Joined: 02 Mar 2012
Posts: 3
Topics: 1
Location: India
|
 Posted: Tue Mar 06, 2012 8:22 am Post subject: DB2 SP Calling through .Net windows application |
 |
|
Hi, I am trying to insert the record into the DB2 DB table through calling the SP on click event,but I am facing the below IBM DB2 error. I have checked the all required parameters, their data types,privileges into DB2 Table, SP & .Net code also & it is same well sets.
DB2 ERROR [07006] [IBM] CLI0102E Invalid conversion. SQLSTATE=07006
ERROR [56098] [IBM][DB2/NT] SQL0727N An error occurred during implicit system action type "3".
Information returned for the error includes SQLCODE "-551", SQLSTATE "42501"
and message tokens "DB2ADMIN|INSERT|EMRDHH.TBLINTEGRATION".
Please help me to resolve this issue.
Thanks,
Kuldip
_________________
Thanks,
Kuldip Jadhav |
|
| Back to top |
|
 |
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Tue Mar 06, 2012 9:08 am Post subject: |
|
|
the user (he who clicked)
does not have authority to INSERT in the table,
does this SP reside in a z/OS mainframe
or is this server db2?
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Tue Mar 06, 2012 1:07 pm Post subject: Re: DB2 SP Calling through .Net windows application |
|
|
| Kuldip wrote: |
Information returned for the error includes SQLCODE "-551", SQLSTATE "42501"
|
Kuldip,
-551 means that you are not Authorized to perform the operation.
Check this link for a detailed explanation of the error
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnmcj12/2.3.248?
Kolusu |
|
| Back to top |
|
|
Kuldip
Beginner
Joined: 02 Mar 2012
Posts: 3
Topics: 1
Location: India
|
| Posted: Thu Mar 08, 2012 6:45 am Post subject: |
|
|
kolusu,
Thanks for your reply Kolusu,
I have checked the privileges for user & its "GRANT" for all.
So assist me some other way to resolve the issue.
Thanks
_________________
Thanks,
Kuldip Jadhav |
|
| Back to top |
|
|
Kuldip
Beginner
Joined: 02 Mar 2012
Posts: 3
Topics: 1
Location: India
|
| Posted: Thu Mar 08, 2012 6:51 am Post subject: |
|
|
dbzTHEdinosauer,
Thanks for your reply,
SP reside in DB2 Server & OS is MS SPK2 on system.
I have checked & the all privileges are Granted to user.
_________________
Thanks,
Kuldip Jadhav |
|
| Back to top |
|
|
dbzTHEdinosauer
Supermod
Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany
|
| Posted: Thu Mar 08, 2012 8:24 am Post subject: |
|
|
| Kuldip wrote: | dbzTHEdinosauer,
...
I have checked & the all privileges are Granted to user. |
1. a user who has GRANT authority does not automatically have the authorities that he can grant.
...a dba can grant update authority to a user, without having update authority himself,
and this is often the case.
2. | Quote: | SQLCODE "-551", SQLSTATE "42501"
and message tokens "DB2ADMIN|INSERT|EMRDHH.TBLINTEGRATION". |
for the second time (by me), the user does not have insert authority,
that is all, nothing else,
i suggest that you stop pounding sand.
_________________
Dick Brenholtz
American living in Varel, Germany |
|
| Back to top |
|
|
GuyC
Supermod
Joined: 27 May 2011
Posts: 35
Topics: 0
|
| Posted: Fri Mar 09, 2012 7:08 am Post subject: |
|
|
-551 auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name
together with the tokens :
DB2ADMIN DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION INSERT ON OBJECT EMRDHH.TBLINTEGRATION |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
