Link to home
Start Free TrialLog in
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.
Avatar of Vikas Garg
Vikas Garg
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial