Re: SQL 229 Error
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 24 Jul 2007 22:44:36 +0000 (UTC)
Gordon (Gordon@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I'm getting the following error when I try to access any of the objects in
my SQL Server database:
Error 229: SELECT permission denied on object 'sysfiles', database
'Seviper', owner 'dbo'.
This error, or one similar to it, is occurring whenever I try to access
Tables, Views, Stored Procedures, Users, or any of the other objects. I
see nothing when I try to look at the tables in this database, not even
the system tables.
Can someone please help?
Apparently you are not logged in with very much permissions, least of
all db_owner permissions. Thus it is not "your" database. Try a different
login.
Where is this server? On your own machine or at a hosting provider?
Somewhere else?
If there is an admin for this server, talk to that person. If you are
the admin for your server, please give us more details on how you
log in etc.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Remote Scripting and Firewall Ports
- Next by Date: Stored Procedure Ignoring Table Permissions
- Previous by thread: Re: Remote Scripting and Firewall Ports
- Next by thread: Stored Procedure Ignoring Table Permissions
- Index(es):
Relevant Pages
|
