Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gsxr1100
Starting Member
1 Post |
 Posted - 2007-12-04 : 00:47:04
|
| Hi,I've having some baffling problems with a java applicaiton!I have an application server called WA01 which used to access two tables on an MS SQL 2000 server via a scheme login. The two tables are:_PurchaseOrderInterface_PurchaseInvoiceInterfaceBoth tables were owned by the scheme user, with enough permissions to read & write. The java application on server WA01 could happily read the data within the tables and write a bit flag back to each row.The MS database has been moved to a new server which no longer allows the java application on server WA01 to access the tables via the scheme login, the only way the java app can view and update the tables is by changing the owner of the tables to dbo. The new server is still MS SQL 2000, with comparible security settings.The java app keeps complaing of an unknown source when trying to access via scheme, is this a domain trust issue between the two servers? Any ideas would be welcomed. I'm not an SQL expert but have a good grasp of the security structure etc.Regards,Alan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-04 : 23:10:52
|
| What do you mean schema login? There is no schema object in sql2k. Did you try access those tables with onwer.tab_name? By the way, don't see anything wrong with dbo as table owner. |
 |
|
|
|
|
|
Scheme login can't access tables owned by scheme