Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Unanswered: Scheme login can't access tables owned by scheme

    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
    _PurchaseInvoiceInterface

    Both 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

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    have you tried using sp_changeobjectowner to return ownership of the objects to the schema (not scheme) you desire instead of dbo?

    -- This is all just a Figment of my Imagination --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •