Stairway to SQL Server Security

Stairway to SQL Server Security Level 6: Execution Context and Code Signing

A fundamental way that SQL Server determines whether a principal has the permissions necessary to execute code is with its execution context rules. It’s all complicated by the possibility that a principal has permission to execute code but doesn’t have permission on the underlying objects accessed by the code, such as the data in a table. This stairway level will explore SQL Server’s execution context, ownership chains, and impersonation, as well as show you how you can control access to data via T-SQL code.

2015-02-04

4,528 reads

Blogs

Suggested Topics in Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

Abuse, Patience, and Understanding

By

I’ve been struggling with an author for a few months. I tried to work...

Daily Coping 21 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SSRS 2016 data source - Azure SQL DB not working

By PJ_SQL

Hello! I am trying to create data source to connect to Azure SQL DB...

cumulative updates in multi instance standalone server

By noobdba

For 2019, how would one go about applying CU on multiple instances in a...

Powershell String was not recognized as a valid DateTime

By webrunner

Hello experts, I'm trying to import some CSV data into a SQL database using...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers