Ownership Chaining | Notes on SQL

Tag Archives: Ownership Chaining

Using EXECUTE AS to control data access

Introduction

Ownership chaining is one process that SQL Server uses to allow stored procedures access to tables where the user might not have permission. It has issues with stored procedures that have dynamic sql – EXECUTE AS is one solution. Continue reading →

Tags: dynamic sql, EXECUTE AS, impersonation, Ownership Chaining, REVERT, SQL, T-SQL

Comments 1 Comment
Categories impersonation, Security, SQL, Training

	PowerShell to Remove… on Finding the SQL Server Error…
	Robert Bernotas on TABLESAMPLE – Basic…
	Derick Tiberi on Using a Certificate to Sign a…
	Marisela Gugerty on SSISDB and Catalog – Par…
	Availability Groups… on Read Committed Snapshot…

Search

Notes on SQL

Using EXECUTE AS to control data access

Recent Posts

Recent Comments

Archives

Categories

Meta