Sep 20, 2016 | Introduction to SQL Server, Kerberos, Security |
David was in Copenhagen this weekend delivering his Kerberos talk Taming the Beast: Kerberos for the SQL DBA to SQL Saturday Denmark. I have had a quick chat with him via email since he got back and he said he had a great time. The event was very well attended with...
Jan 10, 2012 | DavidP, Security |
We’ve all have service accounts, application accounts, sysadmin and domain admin accounts and other privileged shared accounts on our systems. These are all vital to the running of our applications and databases.But do you keep them safe?Are the passwords held...
Jul 18, 2011 | Security, SQL Server 2005, SQL Server 2008 R2 |
Written by David Postlethwaite Security of the SQL database is becoming more and more important these days yet I’m finding that vendors often overlook setting minimum required privileges on a database. Many database I’ve been given to install just assign db_owner to...
Jul 14, 2011 | DavidP, Security, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 |
written by David Postlethwaite Ever wondered who has what access to your database or a particular object within? With the ever increasing need to keep permissions to a minimum this is becoming more important. If you are using Active Directory groups to assign...
Mar 14, 2011 | Security, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQLServerPedia Syndication |
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database role in SQL Server. You can read that post here. This post is going to build on that concept of using database roles for groups of users and allocation...
Oct 28, 2010 | Permissions, Scripts, Security, SQLServerPedia Syndication |
In order to be able to execute bulk operations you need to certain level of privilege both on the database (table) you are performing the operation against and the instance you are performing the operation on.If you don’t have the necessary permissions you will...
