Avatar of Pau Lo
Pau Lo
 asked on

db_datareader issue and hidden table in database/SSMS

I am using SQL management studio and have been granted db_datareader database role to a number of databases on a 2008 R2 instance. I ran the query

SP_MSforeachDB 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE NAME LIKE ''%LLP%'''

this showed me that the table I am after "LLP" resides in the dbcLive database.  However, when I execute:

SELECT * FROM dbcLive.LLP it says object cannot be found. Also in the SQL management studio, when I expand that DB, and expand tables, it does not show this database listed. COuld this be due to secureity permissions (despite me having db_datareader, which I assumed was complete read access to any table in that database.
Microsoft SQL ServerDatabases

Avatar of undefined
Last Comment
Vikas Garg

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Vikas Garg

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23