| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database Error:[IBM][CLI Driver][DB2/6000] SQL0551N |
« View previous topic :: View next topic » |
| Author |
Message
|
| sachinramesh |
 Posted: Fri Apr 18, 2008 3:35 am Post subject: Database Error:[IBM][CLI Driver][DB2/6000] SQL0551N |
 |
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
hi
my flow inserts the data into the database "GODB" based on some validations,the DSN name of the DB is GODBTARG.when i am running the flow in my local system the flow is executing fine and inserting ,but when i am trying to execute the same flow on the other machine with same settings and environment..it says
[IBM][CLI Driver][DB2/6000] SQL0551N "CUDBINST" does not have the privilege to perform operation &
quot;SELECT" on object "GODB.TBL_CU_BASEPACK_SEQ_SYNC". SQLSTATE=42501
What could be the problem. |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Fri Apr 18, 2008 3:44 am Post subject: Re: Database Error:[IBM][CLI Driver][DB2/6000] SQL0551N |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| sachinramesh wrote: |
[IBM][CLI Driver][DB2/6000] SQL0551N "CUDBINST" does not have the privilege to perform operation &
quot;SELECT" on object "GODB.TBL_CU_BASEPACK_SEQ_SYNC". SQLSTATE=42501
What could be the problem. |
user CUDBINST doesnt have the privilege to perform opertation
Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Fri Apr 18, 2008 3:44 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi sachinramesh,
The user that the broker is using to connect and select from database, does not have the authority to do the same.
Talk to your Db admin to GRANT PRIVILAGES.
Regards. |
|
| Back to top |
|
|
| sachinramesh |
| Posted: Fri Apr 18, 2008 4:02 am Post subject: |
|
|
Disciple
Joined: 20 Feb 2007
Posts: 170
|
| elvis_gn wrote: |
Hi sachinramesh,
The user that the broker is using to connect and select from database, does not have the authority to do the same.
Talk to your Db admin to GRANT PRIVILAGES.
Regards. |
Ok
Thanks to both of u |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
