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

	great post on MERGE, OUTPUT and $Action
	SQL Review - Roofer… on OPENXML – Basic Exa…
	Solomon Rutzky on Using a Certificate to Sign a…
	Hoàng on Preserving White Space in…
	How to Script a Cert… on Using a Certificate to Sign a…

Search

Notes on SQL

Using EXECUTE AS to control data access

Recent Posts

Recent Comments

Archives

Categories

Meta