So we’ve recently adopted the use of SQL Server 2008′s Central Managment Server for our development team. Something that tends to get missed or not talked about in articles about CMS is the security required to connect and view the Central Management Server. There are 2 MSDB database roles that relate to the Central Managment [...]
Posts Tagged ‘Security’
Reminder: EDMPASS Meeting Coming Soon #YEG #SQL
OK we’re 2 weeks away from the next EDMPASS meeting!! Speaker: Colin Stasiuk Topic: SQL Security Auditing Through The Ages If you haven’t signed up yet and plan on attending please do so that we can make sure to have enough food and drinks (and seats) for everyone. Click on the link below for more [...]
Running SSIS Packages – Security
So as most of my blog articles this post is inspired by an email I received asking for permissions to run SSIS packages. In SQL Server 2005 there are 3 Database Roles in the msdb system database: MSDN Integration Services Roles 2005 Role Read action Write action db_dtsadmin Enumerate own packages. Import packages. or Enumerate all [...]
Server Role Audit – a quick and dirty script
Every now and again I like to run a quick audit of the SQL Servers I support and ensure that logins do not have any elevated permissions on a server. With properly auditing and tracking you should be able to identify any problems when they happen but it doesn't hurt to give the server(s) a [...]
Database Role Audit (alpha version)
OK so this is kind of a “part 2″ to a post I made a while back about doing a SQL Server Role Audit. I wanted to go to the next level down and do the same type of thing for all database roles (system and user). This is definitely an “alpha version” of the [...]
