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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: