• Post Reply Bookmark Topic Watch Topic
  • New Topic

help needed for MS SQL Server  RSS feed

Yuan Ye
Ranch Hand
Posts: 172
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have used the type4 driver from MS to connect with MS SQL Server. The connection is fine. And I create a new database db1 with table tb1 in SQL server. However after connection, when I try to use a java program to run a SQL like "select * from tb1". It give me the error of
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]SELECT permission denied on object 'tb1', database 'db1', owner 'dbo'.
If I use the same code to access a database coming with SQL server like "pub". Everything is fine. And I have changed given all access permissions of tb1 and db1 to the user I used to connect. Does anyone know how to solve this problem? Thanks
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!