Search code examples
sql-serversql-server-2016row-level-security

Why should I create a separate schema for security objects in SQL Server?


I do want to use the row-level security feature of SQL Server 2016. In the best practice part of the documentation it says:

It is highly recommended to create a separate schema for the RLS objects (predicate function and security policy).

What are the reasons behind this statement? And what is the benefit?


Solution

  • It is purely for organization reasons - it is very usefull to have all the security augmentations on one place (under one schema).

    Benefits are - your database won't look messy.