In DTS, I setup deletion on one table, and the connection
ID in DTS is A user. I also setup a job to run this DTS,
exec master..xp_cmdshell 'dtsrun -S Server -U A -P xxx -N
I already grant A user to have full right on this table,
but the job log still complain the permission. After
grant public role with this permission, then job run
What's the issue here?
Thank you for your help.