I'd like to build a bunch of new databases (several dozen) in SQL Server 2016. However, I'd like all users to access a single database (called SECURITY for now), and apply security to that one database, where each user would be given access to a single schema for their department. Does SQL Server 2016 allow inheritance of security, so you don't have to build those users in each database, and apply the same security in each? Some of these schemas will just have views in which the definitions that read schemas and tables in other databases.
A few of these schemas in DEV_SECURITY will allow read/write and drop/create on views, tables, and stored procedures, for SECURITY, but also one other database.
Does this require me to build out these users, and their security in all databases, or can I simplify by just building them in SECURITY?