What rights does one need to create a dts package, and what rights to see the packages and execute one
TIA
Fred

By default a person only needs a lgon to the server. By default the user
"Guest" is a user in MSDB (dts SPs are here).
See packages - as above
Execute One - You can secure packages with Owner and User passwords.
Without at least the User password then a person cannot execute them. No
password? Thhen so long as you have the rights to do what is being done in
the package then you're OK


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Fred" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks Allan
What would stop a user from creating a DTS package and then scheduling it to run. When it runs, it runs as the agent so it could access resources the user has no right to
TIA
Fred

Remove Guest from MSDB for a start
Also sp_add_job defaults to Public also

You are nearly right about who runs a job but not quite. Have a look here

http://support.microsoft.com/?kbid=269074

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Fred" <anonymous (AT) discussions (DOT) microsoft.com> wrote

user has no right to.