Solved

does not have the privilege to perform operation "EXECUTE" on object "NULLID.SYSSH200".  SQLSTATE=42501

Posted on 2004-03-26
3
3,734 Views
Last Modified: 2012-06-21
Hi,

 I am trying to execure a SELECT query thru my java application connecting to DB2 database, which is in AIX machine.
When i try to execute a query from my java application it's giving the following exception

does not have the privilege to perform operation "EXECUTE" on object "NULLID.SYSSH200".  SQLSTATE=42501

What could be the problem?

0
Comment
Question by:mvkraju
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 50 total points
ID: 10690505
it sounds like your level of  access software has not been bound ....

speak to you DBA...



 
0
 

Author Comment

by:mvkraju
ID: 10690695
i spoke to him,
he said that he did everything what he could at his side.
He believes it's problem with my db2java.zip or db2jcc.jar files
which i use at client side for drivers.


0
 

Author Comment

by:mvkraju
ID: 10690825
O.K. yes it's admin side job.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DB2 tablespace disk full error 33 1,203
as400 interactive sql phone number search 7 137
filter big file based upon on multipe criteria 2 76
iSeries DB2 SQL - Request user input 12 75
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question