August 21, 2011 at 11:33 pm
Hi Friends,
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.
August 21, 2011 at 11:52 pm
The only way that I know how is to uninstall PowerShell from each client PC.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 1, 2011 at 3:22 am
What is the client operating system that is used by your users?
See Books online reference:
Beginning in SQL Server 2008, SQL Server Management Studio supports starting Windows PowerShell sessions from the Object Explorer tree. Also beginning in SQL Server 2008, SQL Server Agent supports Windows PowerShell job steps.
If Windows PowerShell is uninstalled after Setup finishes, the SQL Server features for Windows PowerShell will not function. Windows PowerShell can be uninstalled by Windows users, and uninstalling Windows PowerShell might be required by some Windows operating system upgrades. If Windows PowerShell has been uninstalled and you want to use the SQL Server features, you must do one of the following:
Manually download and reinstall Windows PowerShell 1.0 from the Microsoft Download Center. Download instructions are on the Windows Server 2003 Web site.
If you are running Windows Server 2008, Windows PowerShell 1.0 exists in the operating system but is disabled by default. You can re-enable Windows PowerShell from Windows Server 2008.
-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply