Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    14

    Unanswered: problems whit SQLServer and JDeveloper

    I'm trying to open a new DB conection in JDeveloper 9. I've created a DB in SQL Server 2000 with one user called mta_ds.
    When i look in JDeveloper the connection show me 3 users for that DB (dbo, guest and mta_ds), but with the only user that i can see the tables of the db is with dbo. both dbo and mta_ds had the same permisions and roles. So.. why i can't see the tables for mta_ds?? i've used one driver open source: Driver name = net.sourceforge.jtds.jdbc.Driver
    url = jdbc:jtds://Tauros:1433/DB_Visa_MoraTemprana
    Could be this the problem?

    Pleaseeee Somebody help meeee!!!
    THANK's A LOT!!!!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Run SP_HELPROTECT from query analyzer and see the privileges for individual roles/users.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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