Keeping the DBA out of the database
Play Keeping the DBA out of the database
With the regulations and compliance that many organisations are scrutinised with today, it is often no longer an option for a Database Administrator to be a member of the sysadmin Server Role. If you remove a DBA from the sysadmin Server Role then how do they manage the database platform and perform common administrative functions? In this presentation you will see how the Separations of Duties Framework can be implemented to assist in setting up a restrictive Microsoft SQL Server environment. The presentation provides practical demonstrations based on real-world experience working with classified information. Armed with this information you will be able to configure an environment that limits the processes a DBA can perform, whilst ensuring that they are kept out of the database and away from sensitive information.