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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.