Midlands PASS (Columbia, SC) will be meeting on March 3, 2020, for our monthly user meeting. We’ve been on hiatus since the holidays but we should be meeting regularly again for the rest of the year. The typical schedule (all times are Eastern):
- 5:30 – 6:00 PM: Meet and Greet / Networking
- 6:00 – 7:15 PM: Main Talk
- 7:15 – 7:30 PM: Prizes (if we have any) / Networking
RSVP Link for the March 2020 Meeting: https://www.eventbrite.com/e/sql-server-security-basics-tickets-97152292121
This month I’ll be speaking. Here’s the talk:
SQL Server Security Basics
What do you need to know to work with SQL Server security properly? In this talk, we’ll look at the must knows. We will start with how a person or application connects to SQL Server and the types of authentication SQL Server provides. We will then look at the hierarchical security model SQL Server implements and how this flows down from server all the way down to tables, views, and stored procedures. Afterwards, we will discuss particular security roles which allows access without explicit permissions. Finally, we will look at ownership chaining and how that can also allow a user access to an object because of a reference from a different object.