I have used schemas to secure objects in a database in the past. Is Securables concept works in the same manner and if yes, which should I use to control permission to an object.
We have a database where we do not want the users to have access to any tables, except for 3-5 views. We did this with Securables and it is working well.
I just would like to have a deeper understanding of it. I have googled it already but could not find Schema vs Securables.
Thanks