Hello guys!
I have been in trouble for a couple of days now.
I have recently installed Cognos Express and I use DB2 as datasource. From DB2, ADMIN can do any request and I have successfully add my database as a datasource of Cognos Express.
But in framework manager, when I try to build queries I always receive the message below :
RQP-DEF-0177 An error occurred during the execution of the operation 'sqlPrepareWithOptions' état = '-9'.
UDA-SQL-0107 An error occurred during the operation.
IBM][CLI Driver][DB2/NT] SQL0551N "ADMIN" has no privileges or rights required to perform the operation "SELECT" on object "JERRYVERSON.STAFF". SQLSTATE = 42501
Is it because Cognos Manager Admin and DB2 Adminhas the same username?
Any help will be appreciated.
Thanks in Advance.
Chris who is really in trouble.
Hi Chris,
This seems to be saying that the User ID you entered when you set up the connection to DB2 from Cognos Express does not have any privileges to select data from your STAFF table within the database.
It's not a Cognos Express issue, it's a permissions issue within DB2. Does this (http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14412263) thread help any in getting it sorted?
Cheers!
MF.
Thanks it helps....