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!

  • July 3, 2016 at 5:55 am

    #1888215

    SilentMike (5/20/2016)

    Thanks Ness but I don't think that solves my problem. The user has the exact same permissions (member of db_datareader only) on another database on the same instance and is able to view the table list in Object Explorer.

    Even when I grant them VIEW DEFINITION on the database in question they are still unable to view the table list.

    I believe VIEW DEFINITION must go against MSDB.

    You could also just give db_datareader access to MSDB but that may be too much access. Ive never found an issue doing this but some people are of the mind "Only give them what they need and not a bit more" where security is concerned.