• 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.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/