Hi

I have this error:

Servidor: mensaje 229, nivel 14, estado 5, línea 1
SELECT permission denied on object 'sysobjects', database 'SED', owner 'dbo'.

with this sentence:


select * from sysobjects

I only resolve this grant System Administrators to my user,
but I need make select to sysobjects,sysindexes, etc, etc
without rol System Administrators ,

I already make grant select on sysoobjects to my user but
the error persits

How i can do i t??


Thanks

[posted and mailed, please reply in news]

raulgz (ragaza@ozu.es) writes:
> I have this error:
>
> Servidor: mensaje 229, nivel 14, estado 5, línea 1 SELECT permission
> denied on object 'sysobjects', database 'SED', owner 'dbo'.
>
> with this sentence:
>
>
> select * from sysobjects
>
> I only resolve this grant System Administrators to my user,
> but I need make select to sysobjects,sysindexes, etc, etc
> without rol System Administrators ,
>
> I already make grant select on sysoobjects to my user but
> the error persits

First do a "sp_helprotect sysobjects" in the database in question
to find out if there are any explicit DENY on sysobjects. In such
case revoke these. If there is nothing at all, do

GRANT SELECT ON sysobjects TO public

This is the default permissions for sysobjects.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp