Explanation/Reference:
Explanation:
Executing as OWNER executes the procedure in the context of the procedure owner. If the procedure is created in a schema owned by dbo or the database owner, the procedure will execute with unrestricted permissions.
Members of the db_datareader fixed database role can read all data from all user tables.
References:
https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/customizing-permissions-with- impersonation-in-sql-server
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level- roles