SELECT Permissions denied on MSSQL tables

what are you doing when you get this error?  

you could have someone give you this permission

grant select on schema::sys to yourusername

or you could just have them make you a db_datareader in the db.

Thanks champmandew...I will contact the sysadmin and let him know. Be right back!!

This error occurs as soon as I click on the "Tables" folder in the SSMS Object Explorer.
Still waiting from sys_admin...thanks.

sounds like the sysadmin just needs to give you permission to log into the database for which you're trying to look at the tables.

Still no luck. I am the db_owner.  Why can't I see these tables??? I can create the tables, because they show up on his login. Hmm....

When you say Log into the database, what exactly do you mean? Im a newb big time...

You have been explicitly DENYied permission somewhere.  DENY overrides other permissions (except for 'sa', of course, who can't be DENYied access to any object :-) ).

It's most likely from a group or role you're in.  

tell the admin guy that you need to be able to log onto the sql server instance, and that you need to access the databases on there.

I don't think you can query the system db:
mssqlsystemresource
directly anyway.

I don't think SQL allows anyone to query that db, even sa's.

I see.  The error message implies that the I am trying to access the mssqlsystemresource. However, I just want to view the tables in my SSMS.  

I am connected to the sql server instance.

I can create table which the admin can see, manipulate, etc.

I can even create my own schema.

Ugh...

The mssqlsystemresource database is a resource database that is hidden and is used to manage metadata for SQL Server.

What the error message is telling you is that there is information in the extended properties of the table that you do not have access to.  I am not sure why you cannot get to them using the dbo user.

But one thing is for sure, if the admin can see these and not get the errors, then it is a permissions issue and you need to have the sysadmin determine the permissions that are being explicitly denied so that it can be corrected.  DENY does override the GRANTs, so there is something like View Definition permission or some other permissions that have been denied and is causing you problems.