Rochester PASS

Gold Sponsors



Upcoming Chapter Events

Next Meeting: Thu, Sep 21 2017

September Meeting - A Solution for Securing SQL Agent Jobs & Packages by Team

Language: English
Event Type: In-Person
Online Meeting URL: None

Summer has passed and our meetings resume! Join us this month for a presentation from a new local speaker!


UTC : Thu, Sep 21 2017 22:00 - 00:00
Event Time : Thu, Sep 21 2017 18:00 - 20:00 Eastern Daylight Time
Your Local Time: Thu, Sep 21 2017 22:00 - 00:00


800 Bausch & Lomb Place
Rochester, New York

Direction: None

Featured Presentation

A Solution for Securing SQL Agent Jobs & Packages by Team

Speaker: Janetta Morton

Summary: If you’ve ever tried to configure a SQL Server instance to host multiple project teams in a way that keeps their work separate, you have probably discovered that this is not a straight forward task. In fact, although the security offerings in SQL Server 2005 and above are more granular than for prior versions of SQL Server, it does not provide a way to allow groups of jobs and SSIS packages to be managed by a team, short of giving the entire team sysadmin privilege. In this presentation we’ll take a look at a security solution that can be implemented in a SQL Server 2005 or higher environment which controls privileges in the SQL server environment by the role filled by a team or sub-team. Included will be a set of custom configuration objects which can be installed in a SQL Server instance to grant privileges for a group of jobs and SSIS packages to a team or sub-team based on the role they fill.

About Janetta: Janetta Morton has been a SQL Database Administrator at ACM Medical Laboratories for 3+ years. Prior to this, she served provided both SQL DBA and Data Architect services at Eastman Kodak. During her 32 years at Kodak she handled a variety of tasks including application design and implementation, project planning and management, process design and automation, database design and support, problem solving, documenting, and coaching/training/mentoring.


Back to Top