Posts under ‘Security’

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 Server:
ServerGroupReaderRole:  [...]

Well here we go.. my first podcast.
Big thanks to Brent Ozar for helping both by critiquing the video ahead of time (and providing some very valuable feedback) as well as offering to encode, setup, and host the video on SQLServerPedia.com.
In watching the video on SQLServerPedia I’m already thinking of ideas for topics of future webcasts [...]

In July the Edmonton Chapter of PASS is going to have it’s 2nd meeting. Details below:
http://www.eventbrite.com/event/378687665
Please be sure to not only click the “Add to my calendar” but also the “Register” button so that we can plan accordingly for food and drinks. 
Date:  July 29th 2009
Time: 5:00 pm – 7:00 pm
Location: Stanley A. Milner library
Map: 7 Sir Winston Churchill Square
Meeting [...]

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 packages.
Delete own packages.

sysadmin
View own packages.
Delete all packages.

 
View all packages.
Change own [...]

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) [...]