View previous topic :: View next topic
|
Author |
Message |
Young zhang
New User
Joined: 13 Jun 2008 Posts: 15 Location: china
|
|
|
|
DSNX200I -DB2A BIND SQL ERROR
USING GELTP AUTHORITY
PLAN=(NOT APPLICABLE)
DBRM=IBAUPD
STATEMENT=260
SQLCODE=-551
SQLSTATE=42501
Here is the error, how to solve it. Thank you! |
|
Back to top |
|
|
eHorizon.Andrew
New User
Joined: 18 Jan 2007 Posts: 28 Location: Bank of communications
|
|
|
|
-551 auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name
may this be of help~ |
|
Back to top |
|
|
Young zhang
New User
Joined: 13 Jun 2008 Posts: 15 Location: china
|
|
|
|
So, which id does not have the privilege? the id should be DB2 creater's id or I can not use owner GELTP ? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Check with your dba/security people to make sure you have/get the needed permissions (or you will not be able to execute this). |
|
Back to top |
|
|
Young zhang
New User
Joined: 13 Jun 2008 Posts: 15 Location: china
|
|
|
|
Hi eHorizon.Andrew and dick scherrer,
Thanks for your help, I will try to solve the problem. |
|
Back to top |
|
|
|