Saturday, February 25, 2012

Permission necessary for a normal user to create and run DTS? Thanks.

Permission necessary for a normal user to create and run DTS? Thanks.By default, anyone with a login can create a Package as the
public role has execute permissions on sp_add_dtspackage
stored procedure in msdb and the guest account is enabled in
msdb so it depends on whether you have changed this or not.
Other than that, the user would just need the appropriate
permissions for the objects they are accessing or actions
they are performing.
-Sue
On Mon, 19 Jul 2004 16:00:10 -0400, "john" <john@.aic.com>
wrote:

>

No comments:

Post a Comment