Securing SQL Server – Principal of least Privileges

In this second video of the series we cover “Principle of least privileges”. It means we grant only the minimum required permission to any account. We explore how to grant these permissions and also how once granted, bad coding practices and carelessness can undo all the hard work in one swoop.

This is one of the most fundamental tasks any DBA is expected to know and so we cover the basics in depth. We demonstrate how SQL injection occurs towards the end of the video to show how despite implementing this security feature hackers can get access to your data. It is important to know the details of how to implement this feature since it is in most companies the only thing done to protect the data.