07 – Application Logon & Execute As

Application logons are a feature SQL Server has had since SQL 2005 and is rarely used.

It serves as a layer of security where the user can only access data through an application.

This works because the application works with the user to grant the permission and access needed after they connect.

We will review the concept of the application login, take a look at how this work,s and play with a little app (provided) so you can see just how it works.

We will also go over the impersonation command of “EXECUTE AS”.

You may know this from stored procedures and such, but there is a second use that lets us impersonate another user so we can check things out without having to get hold of their password.

Duration 60-minute Discussion and hands-on labs