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!

  • I would guess that the difference would be in the server level permissions for public and a difference between those for the two environments, especially for the permissions VIEW ANY DATABASE. That's just my guess though, could be other things but I have seen this permission causing similar issues, confusions.

    Sue