permissions question - SQL Server 2008

#1

I have a user who wants to create a 'job' in SQL Server...

This job will run a SQL query and generate an email nightly

I want to give the user the minimum requirements to create/edit this job

He can't see the SQL Agent tab in Management Studio

Thoughts?

#2

Add the user to the SQLAgentUserRole role in the MSDB database.

Change the user to be the owner of the job.

Here is the BOL link describing SQL Agent Security.
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Blake" <blake.duffey (AT) gmail (DOT) com> wrote

Quote:

I have a user who wants to create a 'job' in SQL Server...

This job will run a SQL query and generate an email nightly

I want to give the user the minimum requirements to create/edit this job

He can't see the SQL Agent tab in Management Studio

Thoughts?

#3

Thanks

I haven't been able to find where to assign that role - it isn't the
same place as the bulkload role, for example

Thanks
Blake

Geoff N. Hiten wrote:

Quote:

Add the user to the SQLAgentUserRole role in the MSDB database.

Change the user to be the owner of the job.

Here is the BOL link describing SQL Agent Security.
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm

#4

It is a database role within the MSDB database.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

"Blake" <blake.duffey (AT) gmail (DOT) com> wrote

Quote:

Thanks

I haven't been able to find where to assign that role - it isn't the same
place as the bulkload role, for example

Thanks
Blake

Geoff N. Hiten wrote:
Add the user to the SQLAgentUserRole role in the MSDB database.

Change the user to be the owner of the job.

Here is the BOL link describing SQL Agent Security.
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/719ce56b-d6b2-414a-88a8-f43b725ebc79.htm

#5

Thanks so much for your help, Geoff

I appreciate it!

Blake

Geoff N. Hiten wrote:

Quote:

It is a database role within the MSDB database.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

permissions question - SQL Server 2008

microsoft.public.sqlserver.server microsoft.public.sqlserver.server

permissions question - SQL Server 2008 - 08-18-2009 , 03:21 PM

Re: permissions question - SQL Server 2008 - 08-18-2009 , 03:51 PM

Re: permissions question - SQL Server 2008 - 08-18-2009 , 04:16 PM

Re: permissions question - SQL Server 2008 - 08-18-2009 , 06:24 PM

Re: permissions question - SQL Server 2008 - 08-19-2009 , 06:57 AM