• jchapman (1/29/2013)


    ...

    I have a test user called "LowAccessTest", who exists as a user in DataMart but has no specific privileges (If I give this user db_datareader, they can see everything in the datamart database).

    Why you want add LowAccessTest to role db_reader in the DataMart? You should give him only select on the table