SQL: What is REFERENCES permission and why does it matter?

added by DotNetKicks
10/31/2018 12:22:43 PM

1 Kicks, 1060 Views

I was at a client site the other day and they were puzzled by SQL Server object permissions. In particular, they couldn't understand what the point of the REFERENCES permission is. It seemed pointless to them. It's not. Let me explain why. Keep in mind that if all the objects in the database have the ...