Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Invalid Object exception

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to use the jdbc-odbc bridge to access a SQL database. I have created several user tables with a dbo-level user. I am trying to connect to the database with another dbo-level user, but I keep getting an exception trying to access the user tables. It works fine when I retrieve system tables, so I know the connection is okay. I'm assuming this is a SQL server issue. Anyone have clues?
Thanks,
Chris
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, this sounds like a database issue. If you create a table as one user, that user has to grant permissions for other users to use it. Additionally other users must use the full name for the table which is usually owner_name.table_name or an administrator has to create a synonm for the table so that everyone can access it with just table_name. Consult the documenttations for your database on grants and synonms.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic