SQLTeam.com | Weblogs | Forums

Securables vs Schemas

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

I think I got it. Schema is really like a folder and I apply the security against the Schema instead of single files. Securable is the practice of applying the security. So in this case, I can secure a Schema (which would apply to all objects under this schema) or just a single object.