| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Database exception-insufficient privileges |
« View previous topic :: View next topic » |
| Author |
Message
|
| wmqiadmin |
 Posted: Thu Mar 08, 2007 9:38 am Post subject: Database exception-insufficient privileges |
 |
|
Disciple
Joined: 19 Jun 2005
Posts: 163
Location: epping UK
|
Hi All,
I am trying to run the following code on V6 Broker.
| Quote: |
SET Environment.Variables.ErrorInfo[] = SELECT
P.ERR_CD FROM Database.comline.MQ_ERR_RETRY_CONFIG AS P ; |
Where i am getting error :
| Quote: |
Text = [DataDirect][ODBC Oracle driver][Oracle]ORA-01031: insufficient privileges
|
I have set the compute node parameter, the latest changes I have done is I have chaged the dbparam cmd to give get full access on the tables by giving mqsisetdbparam cmd, restarted the server.
in registry editor i can see the current user under DataSourse(MyDataSourseName) folder, under broker folder i don't see any files axcept defaut, same with Broker_name folder, and under current version folder i can see the broker DSN details (Broker DB user).
I am able to run the same cmd from SQL plus.
can any buddy help me here?
Thanks in advance.
wmqiadmin |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Mar 09, 2007 4:36 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You're sure that the database user you configured for the DSN with mqsisetdbparms has the access you require?
Can you ask your Oracle DBA for more assistance tracing what's happening?
Can you enable ODBC tracing, according to the steps in the Broker Info Center, and see if that shows you what's going on?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| wmqiadmin |
| Posted: Fri Mar 09, 2007 8:55 am Post subject: |
|
|
Disciple
Joined: 19 Jun 2005
Posts: 163
Location: epping UK
|
Thanks Jeff for your guidance.
One question still not cleared, I have 2 users with different access on myDatabase, one (user1) other(user2).
user1 is my brokers DB user and it has full access on its table (brokers DB tables) and limited access on other tables which are accessed from message flow.
user2 is my message flow user with full access on its tables, not on brokers tables offcourse.
I have added the user2 through mqsisetdbparams cmd and it works fine with the insert statement.the problem is when i run the select statement in the compute node it fail with the reason ... insufficient privileges which accoring to me should be wrong....because it has full privilages on the respective tables.
Now i have got complete access for user1 on the message flow table and its working. Do i need to have to complete access for user1(broker DB user) on the other tables where message flow updates or access the tables (Database)?
any comments on this? |
|
| Back to top |
|
|
| brokerDev |
| Posted: Thu Mar 15, 2007 4:07 pm Post subject: |
|
|
Acolyte
Joined: 21 Jun 2006
Posts: 53
|
Hi,
Have you tried running the exact SQL statement in the compute node manually (i.e. through SQLPlus or TOAD) using the same userid/password that you assigned via mqsisetdbparms? This should help with the troubleshooting.
Regards, |
|
| 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
|
|
|
|
