Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: user

The SQL Server security model, part 1: principals

There are a number of layers in the SQL Server security model, giving you a nearly infinite number of ways to set up access control on your server and databases. Security is a huge topic, and there are literally entire books on it, so this series of articles is designed to give you just a quick overview of the SQL Server security model to get you started.

In this first installment, I’ll go through the different types of security principals that are available, as well as how they connect to each other.

Continue reading The SQL Server security model, part 1: principals
Published 2014-07-20
Categorized as Basics, SQL Server concepts, SQL Server security Tagged application role, database role, inheritance, login, orphaned users, principal, security, server role, user

A short introduction to application roles

Application roles provide a practical way to assign application-specific permissions in your database and to make sure that your applications always use a defined login. Not to be confused with actual roles, application roles are more like users in the database.

Continue reading A short introduction to application roles
Published 2013-04-21
Categorized as Basics, SQL Server concepts, SQL Server security, T-SQL Tagged application roles, login, logon, permissions, security, user
sqlsunday.com
Proudly powered by WordPress.