Results 1 to 3 of 3
  1. #1
    Join Date
    May 2007
    Location
    Calgary, Canada
    Posts
    22

    Unanswered: Schemas, views, and ODBC

    I have some tables sitting in schema "A", then I created a view in schema "B" based on the tables in schema "A". Then I gave the user just access to schema "B" to only run the view but not see the tables in schema "A".

    Could it be that if the user tried to ODBC to that db, they would only see the view in schema "B" and not the tables in schema "A"?

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Nope. Have a look at Ownership Chaining in Books Online (BOL). When you cross schemas, the user needs to have permissions on the underlying objects, because the ownership chain is broken.

  3. #3
    Join Date
    May 2007
    Location
    Calgary, Canada
    Posts
    22
    Quote Originally Posted by MCrowley
    Nope. Have a look at Ownership Chaining in Books Online (BOL). When you cross schemas, the user needs to have permissions on the underlying objects, because the ownership chain is broken.
    OK... thanks!

Posting Permissions

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