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!

  • June 17, 2013 at 4:04 am

    #1624516

    Roy gave the answer. This is expected behaviour if the login is not granted view definition

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk