sql server dts: Error 229: Permissions problem with sysobjects and sysindexes -- sql server dts

Error 229: Permissions problem with sysobjects and sysindexes

Ben Fidge
8/30/2005 12:00:00 AM

sql server dts:

Hi,

I'm trying to view a database using Enterprise Manager and am getting the
following error when I try to view the list of tables, stored procs etc:

Error 229: SELECT permission denied on object 'sysobjects', database
'tours180805', owner 'dbo'.
SELECT permission denied on object 'sysindexes', database 'tours180805',
owner 'dbo'.

I'm not actually the administrator of this database, and all I know is that
it's a snapshot of a live database setup for me to develop against while i'm
writing a B2B link. As such I don't know what method was used to make the
copy, and if anything has been left out during copying. I don't have these
problems when viewing the live version.

Any help gratefully received.

Ben Fidge

Re: Error 229: Permissions problem with sysobjects and sysindexes

Allan Mitchell
8/30/2005 8:43:22 PM

Have you tried here?

http://www.derkeiler.com/Newsgroups/microsoft.public.sqlserver.security/2003-03/1061.html

[quoted text, click to view]

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.