error 229

Hello there !
I encountered this error when i followed next steps:
started Enterprise Manager >> My SQL Server group >>
Databases >> Tables
This is the error description:
Error 229 :
1)SELECT permission denied on object 'sysobjects'
database 'diamond', owner 'dbo'
2)SELECT permission denied on object 'sysindexes'
database 'diamond', owner 'dbo'
When i selected my database(diamond) & right clicked then
same error occured but with different objects -
'sysfiles', 'sysusers', 'sysfilegroups'The owner of the 'diamond' database hasn't granted you any permission to
view the contents. Get the owner of the database to grant you permission and
retry.
--
HTH
Ryan Waight, MCDBA, MCSE
"Deepak Sakpal" <deepaksakpal@.hotmail.com> wrote in message
news:183d01c3865c$aff6b4c0$a301280a@.phx.gbl...
> Hello there !
> I encountered this error when i followed next steps:
> started Enterprise Manager >> My SQL Server group >>
> Databases >> Tables
> This is the error description:
> Error 229 :
> 1)SELECT permission denied on object 'sysobjects'
> database 'diamond', owner 'dbo'
> 2)SELECT permission denied on object 'sysindexes'
> database 'diamond', owner 'dbo'
>
> When i selected my database(diamond) & right clicked then
> same error occured but with different objects -
> 'sysfiles', 'sysusers', 'sysfilegroups'|||Seems like someone revoked SELECT permission on those system table for the public role. Or perhaps
DENY the permissions.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Deepak Sakpal" <deepaksakpal@.hotmail.com> wrote in message
news:183d01c3865c$aff6b4c0$a301280a@.phx.gbl...
> Hello there !
> I encountered this error when i followed next steps:
> started Enterprise Manager >> My SQL Server group >>
> Databases >> Tables
> This is the error description:
> Error 229 :
> 1)SELECT permission denied on object 'sysobjects'
> database 'diamond', owner 'dbo'
> 2)SELECT permission denied on object 'sysindexes'
> database 'diamond', owner 'dbo'
>
> When i selected my database(diamond) & right clicked then
> same error occured but with different objects -
> 'sysfiles', 'sysusers', 'sysfilegroups'