He has read only access to the tables or to the packages?

--
Denny Cherry
DBA
GameSpy Industries
"Naser" <nrashed (AT) stc (DOT) com.sa> wrote

DTS packages are in the main stored in MSDB.
Guest is a user in MSDB (unless your DBA has changed this)
This means that anybody can grab a package (So long as they are not PWD
protected)
You should then be able to execute the packages so long as the person's NT
account is on the server.

R/O permissions to what? If the User has RO permissions on the table you
are going to INSERT into then it will fail.(If the package connections are
using NT authentication.

Try

Create a SQL user with INSERT and SELECT perms on the destination, SELECT on
the Source
Use this in the connections for the packages

Now create a user who has nothing other than server access.
Log in as that user

Try fire the package.



--

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



"Naser" <nrashed (AT) stc (DOT) com.sa> wrote