user unable to execute a DTS Package -
10-17-2006
, 06:06 AM
Hi,
There is a package ' P' that is owned by a user "O"[Domain account with
sysadmin/administrator rights]. Another user "U", who is not a
sysadmin,
but is db_owner of the DB that holds the Packages' objects, was not
able
to execute the package "P".
Can anyone help "U" execute the Package with minimal permissions
allotted??
like any permissions on msdb or so....
User "U" should only be able to execute the package but not edit it.
Advance Thanks,
Sasiraj. |