Geek Sync Webcast : SQL Server Security Basics

Presenter: K. Brian Kelley
Share This:  Facebook Twitter LinkedIn

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.

Speaker:

K. Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. In addition to being a database administrator, he has served as an infrastructure and security architect encompassing solutions with Citrix, virtualization, and Active Directory. Brian is also a Certified Information Systems Auditor (CISA) and has been the head of a financial organization’s computer incident response team. Brian is active in the IT community having spoken at DevConnections, SQL Saturdays, code camps, and user groups.

Register for Free Webcast

Register For a Free Whitepaper

Use this property to display a short description or any instructions, notes, or guidelines that the visitor should read when filling out the form. This will appear directly below the form name.
*
*
*
*
*

Join Our Global Community

Join our email list and receive the latest case studies, event updates, product news, and much more.