To let a user view other people's DTS package (readonly),
what permission should give to the user?
Thanks for help.

-Tom

You can't really grant READ-ONLY to a DTS package.

You can apply an Owners password which means you can do whatever you like to
it
OR
You can apply a User's password which means you can't edit the package
rather you can only run it

READ-ONLY really only comes into play on the objects you manipulate so say
the package pumps to ServerB dbA tableA and you only have RO permissions
then you will get a message similar to

"INSERT permission denied on XXX"



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


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

In message <14bb01c3df8f$6ba504c0$a501280a (AT) phx (DOT) gbl>, Tom Totrian
<anonymous (AT) discussions (DOT) microsoft.com> writes
There is no concept of permissions around the package itself. A package
is just a load of COM objects and collections. You can secure the
storage of a package, either as a file or in the msdb database (Local
Packages or SQL Server packages). If you wish to restrict access to
packages stored in SQL Server you can control SQL permissions on the
stored procedures sp_enum_dtspackages, sp_get_dtspackage,
sp_add_dtspackage and sp_drop_dtspackage, all in msdb.

You can even go so far as to change them to implement your own security
mechanisms, such as restricting the packages available to each user for
example. This would of course be unsupported by MS.

Since you mention other peoples packages there is an issue with
non-sysadmins and the package owner, but this is only a problem when
saving a package you do not own, if you are not a sysadmin.

Package Ownership Issues
(http://www.sqldts.com/default.aspx?212)


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Allan, Thanks for help.