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: execute as

The SQL Server security model, part 4: execution context

This is the fourth installment in this series on SQL Server security. Today, we’re going to take a closer look at some key security concepts concerning object ownership and ownership chaining as well as execution context and impersonation in SQL Server. This could get technical.

Continue reading The SQL Server security model, part 4: execution context
Published 2014-08-10
Categorized as Intermediate, SQL Server concepts, SQL Server security Tagged alter authorization, execute as, execution context, impersonation, original_login, owner, ownership chaining, suser_sname, with execute as

The SQL Server security model, part 2: securables

Continuing on last week’s post on security principals, this week’s installment in the series on SQL Server security takes a look at securables.

Continue reading The SQL Server security model, part 2: securables
Published 2014-07-27
Categorized as Basics, SQL Server concepts, SQL Server security Tagged caller, execute as, execution context, inheritance, owner, ownership, permission, schema, securable, self
sqlsunday.com
Proudly powered by WordPress.