Midlands PASS: SQL Server Security Basics

,

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.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate