Hello,

I have downloaded the Microsoft SQL Server 2000 DTS Designer Components so
that i can view SQL 2000 DTS packages through SSMS.

I then created a sql login on the SQL 2000 box, made a connection to that
box through SSMS, and when i try to browse the list of DTS packages I am
presented with an error message (number 229):

SELECT permission denied on object 'sysdtspackages', database 'msdb', owner
'dbo'.

So, what exactly do I need to do in order for a user to see these packages?
Do I need to assign some specific permissions inside of msdb? why? how is
this component trying to make a connection in such a way that permissions
need to be set? In SQL 2000 any user would be able to browse the list of DTS
packages, what is different in this case?


--
Thomas LaRock
Database Administrator
ING Investment Management

FYI...

As a quick workaround, I granted select rights on that table to the public
role. My users can now use the component to not only see the list of packages
through SSMS, but they can edit them as well.

Again, why should the step even be necessary?

--
Thomas LaRock
Database Administrator
ING Investment Management



"Thomas LaRock" wrote: