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

	Availability Groups… on Read Committed Snapshot…
	Availability Groups… on Monitoring the Version Store i…
	XML AUTO – Bas… on XML RAW, ELEMENTS and ROOT…
	vara prasad on How to Script a Certifica…
	great post on MERGE, OUTPUT and $Action

Search

Notes on SQL

Using EXECUTE AS to control data access

Recent Posts

Recent Comments

Archives

Categories

Meta