Skip to main content

alphaWorks  >  forumlabel  >  Starter Toolkit for DB2 on Rails  >  developerWorks

Auth error when adding add_index on zos connection    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

loginbox.header
 loginbox.welcomelabel loginbox.guestlabel
loginbox.signin
Permlink Replies: 0 - Pages: 1
jlueke

Posts: 5
Registered: Jun 03, 2008 11:32:28 AM
Auth error when adding add_index on zos connection
Posted: Jun 03, 2008 03:13:38 PM
Click to report abuse...   Click to reply to this thread Reply
When I add the add_index method to my db/migrate/*.rb I get an sql error:

ActiveRecord::StatementInvalid: IBMCLI DriverDB2 SQL0551N "user" does n
ot have the privilege to perform operation " " on object "user.WORKSTMTS". SQ
SQLCODE=-551: CREATE INDEX index_workstmts_on_sow_id ON workstmts (sow_id)

Of course since I just created the table I am the owner and thus do have access to create the index. Just an odd error fyi.

Point your RSS reader here for a feed of the latest messages in all forums