what privilege does the user has to have to create a dts package?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 by default so it depends on whether you have changed
this or not.
But they don't need to be a sysadmin to create packages.
It's generally controlled through sp_add_dtspackage.
-Sue
On Thu, 24 Feb 2005 09:35:07 -0800, "sabby"
<sabby@.discussions.microsoft.com> wrote:
>what privilege does the user has to have to create a dts package?|||Thank you so much.
"sabby" wrote:
> what privilege does the user has to have to create a dts package?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment