Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Agent Job

Author  Topic 

frank.svs
Constraint Violating Yak Guru

368 Posts

Posted - 2011-08-22 : 01:34:05
Hi,

I have question.

In manegement studio, if we right click a sql agent job, we have an option "Start Powershell".

I want DENY permission for a user to start the Powershell.

How to do that?

I can use revoke permissions from msdb roles sQLAgentUserRole,SQLAgentReaderRole and SQLAgentOperatorRole.
But i dont want to touch the predefined roles and am looking for something explcit DENYing permissions for the below.

Thanks in Advance.

   

- Advertisement -