July 20, 2010 at 4:26 am
HI EXPERTS,
How can i restrict a windows user from access only SSIS in my system??
Now I am given him sysadmin Privileges.
Many Thanks
Ratheesh.K.Nair
July 20, 2010 at 5:09 am
Hi ratheesh,
If the user wants to run the SSIS package in the sever, you can use the concept of Credential and Proxy account available in SQL Server.
Please refer the artcile in SSC below:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/68625/
John
July 20, 2010 at 7:12 am
The user need to access froma remote machine..He needs full access to SSIS
July 20, 2010 at 7:47 am
This article speaks to the Windows Security that is needed to avoid adding the user to the Administrators group on the server:
http://msdn.microsoft.com/en-us/library/aa337083.aspx
You may want to look into the MSDB roles as well:
http://msdn.microsoft.com/en-us/library/ms141053.aspx
If you need them to manage the SQL Agent jobs, you should look into the MSDB roles for the SQL Agent:
http://msdn.microsoft.com/en-us/library/ms188283.aspx
Hope those links steer you in the right direction.
Regards,
Steve
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply