SELECT Permissions denied on MSSQL tables

Hi there.
 
I was recently granted access to a database on server BF-SQL1. However, I cannot view any of the tables due to an error creating the message:

SELECT permission denied on object 'extended_properties', database 'mssqlsystemresource', schema 'sys'.


I have searched everywhere and have not been ale to find anything to help me.

please help!!!
Thanks...
suicehockey44Asked:
Who is Participating?
 
suicehockey44Connect With a Mentor Author Commented:
I have found another method of doing this. Thank you.
0
 
chapmandewCommented:
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.
0
 
suicehockey44Author Commented:
Thanks champmandew...I will contact the sysadmin and let him know. Be right back!!
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
suicehockey44Author Commented:
This error occurs as soon as I click on the "Tables" folder in the SSMS Object Explorer.
Still waiting from sys_admin...thanks.
0
 
chapmandewCommented:
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.
0
 
suicehockey44Author Commented:
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....

0
 
suicehockey44Author Commented:
When you say Log into the database, what exactly do you mean? Im a newb big time...
0
 
Scott PletcherSenior DBACommented:
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.  
0
 
chapmandewCommented:
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.
0
 
Scott PletcherSenior DBACommented:
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.
0
 
suicehockey44Author Commented:
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...
0
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.