• Hugo Kornelis (7/23/2008)


    There's a HUGE difference between "Allows the owner of another table to use columns in the table to which they've been granted that permission" (the supposedly "correct" answer to this QotD), and "allows the owner of another table to use columns in the table to which they've been granted that permission as the target of a REFERENCES FOREIGN KEY constraint with his or her table" (the actual correct answer, included in the explanation but not available as an answer - emphasis added by me).

    Please correct the question, as this may be very confusing for people who just check the questions and answers without actually checking the complete explanation as well.

    Agreed. REFERENCES is about referential integrity. The word "use" could be interpreted as "SELECT or UJPDATE". Very poor wording.

    Tom Moreau

    SQL Server MVP