Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

help needed for MS SQL Server

 
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic