NETHERLANDS ACCESS DEVELOPER DAY 2019

Presentation: SQL Server Security for the Access Developer

Speaker: Anders Ebro (Exacto)

Presentation

Being a good developer is more than just having a smoothly designed app. We also need to make sure our client’s data is secured as much as practical.
Join Anders in this walkthrough on setting up and securing a SQL database, starting with the basics of creating a user. We will discuss security with a strong emphasis on choosing a security model that is appropriate for the sensitivity and criticality of the application you are developing.

All applications are not created equal, and it’s important that we don't end up spending half our client’s budget on creating a super secure (but unusable) application.
We will cover such areas as logins, users, AD groups, permissions, rights, database roles, user roles, audit tables, row level security and column level security, and how we can make it all fit into an access world.

About Anders Ebro

Originally an engineer with a degree in Applied Physics, Anders started working with Access in 2008 and hasn’t looked back since.
Anders has made applications ranging from Requirement Tools to financial depreciations, and has been an Access MVP for 4 years.

On his blog TheSmileyCoder you can find code samples among others for treeviews, change tracking, and error/crash reporting.
Anders is Principal Consultant at Exacto.