Home Forums SQL Server 2008 Security (SS2K8) User (db_datareader) can't see tables in MS; can SELECT data! RE: User (db_datareader) can't see tables in MS; can SELECT data!
Orlando Colamatteo
SSC Guru
Points: 182276
More actions
June 1, 2013 at 4:59 pm
#1620303
When logged in as this user, what do you get when you run:
SELECT *
FROM sys.tables;
There are no special teachers of virtue, because virtue is taught by the whole community.--Plato