SQL Server 2000 权限问题! 急, 在线等!
用Microsoft的JDBC Driver 连接SQL Server 2000.
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection("jdbc:microsoft:sqlserver://Server:1433;user=po1;password=po1;DatabaseName=NorthWind");
String sql = "SELECT * FROM Categories";
stmt.executeQuery(sql);
问题是总是得到如下异常:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]SELECT permission denied on object 'Categories', database 'Northwind', owner 'dbo'.
对于MSSQL是新手, 但我认为该设的用户和权限都设妥当了.
其他 UPDATE, INSERT, DELETE 都会出现同样异常. 肯定是SQL permission 设定的问题, 但不知错在哪里?