:::: MENU ::::

Purpose of the REFERENCES permission

DBA Interview questions, dbDigger, Logins and Users, Security and Permissions

Purpose of the REFERENCES permission

Question: What is the purpose of the REFERENCES permission?

Answer: Allows the owner of another table to use columns in the table to which they’ve been granted that permission as part of a foreign key.

Explanation: Assigning REFERENCES permission 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. However, that person won’t be allowed to change the structure of the table they’ve been granted the permission for.

Note: The Question of day is taken from SQLServercentral.com. I want to compile selected QOD.

Consult us to explore the Databases. Contact us