We help IT Professionals succeed at work.

The SELECT permission was denied on the object 'sysdtspackages90', database 'msdb', schema 'dbo'.

miral13
miral13 asked
on
Can anybody tell me if I need to setup something for the error "The SELECT permission was denied on the object 'sysdtspackages90', database 'msdb', schema 'dbo'."?
Thank you in adnace
Comment
Watch Question

Adam MenkesC# ASP.NET Developer
Top Expert 2010

Commented:
You will need to grant those rights to the users that you want to allow access to that table. Or are you getting this error logged in as admin?

Author

Commented:
My user is sysadmin on that server.
Adam MenkesC# ASP.NET Developer
Top Expert 2010

Commented:
And this is SQL Server 2005? Or 2008? Since  msdb.dbo.sysdtspackages90 exists on 2005 and is msdb.dbo.sysdtspackages on 2008

Author

Commented:
SQL Server 2005, sorry
Commented:
This error was caused by the fact that the db from which the select * from   msdb.dbo.sysdtspackages90 was being executed was not set as trustworthy.