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: delegation

The SQL Server security model, part 3: permissions

This is the third installment in a series on assigning SQL Server permissions. In the previous posts, we’ve looked at security principals (the users and groups that carry the permissions) as well as the securables (the objects you want to control access to). Building on this understanding, we’re getting ready to look at the fabric that connects principals with securables: Permissions.

Continue reading The SQL Server security model, part 3: permissions
Published 2014-08-03
Categorized as Intermediate, SQL Server concepts, SQL Server security Tagged administrator, delegation, deny, fixed database role, grant, hierarchy, impersonation, implicit, inherited, original_login, permission, revoke, suser_sname, with grant
sqlsunday.com
Proudly powered by WordPress.