Add new SQL statement EXECUTE AS

Why it matters

This feature allows users to execute queries or operations with the privileges of another user, facilitating better access control, auditing, and security management by enabling impersonation scenarios.

How to use it

Use the new EXECUTE AS statement in your SQL queries to specify the user context under which the subsequent commands will run. For example:

EXECUTE AS 'username'
SELECT * FROM table_name;