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!

  • Ness (6/17/2013)


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

    Not exactly. Revoke (i.e. not being granted or denied a permission) is different than being explicitly denied a permission. If you have select permissions on a table you can see the metadata as well so the expectation is that if you are granted db_datareader then you should be able to see the metadata for all tables.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato