SQL Server 2019: Implementing Security with Users, Schemas, and Roles

Описание: This was presented by Jody Meyer at Virtual Fox Fest 2020: https://virtualfoxfest.com/

You would think that implementing SQL Server database security should be a simple topic. All you want to do is to grant a specific login a specific capability. For example, you want to setup a user with the ability to update some tables' content in a specific database. For another, you want to just allow the user to view content of some tables in a specific database. However, with SQL Server, setting up security can get complicated very quickly. There are many different scenarios and situations which create a staggering number of considerations for a final implementation. And, as time goes on, new demands of the industry are always popping up and with each new release of SQL Server the options available to us can be mind boggling. We now have 248 unique SQL Server permissions with SQL Server 2019. Seriously, all you want to do is insure that each user only has access to the data that is specific to their need and nothing else. So, how can we do that in such a way that is both manageable yet effective? Well, that's what this session is all about. Jody will discuss and demonstrate a simple baseline understanding of how SQL Server manages security.