Ok, I'm at a client site where they want to make a program database independent. This is a rewrite of an existing program that used an Access database only. I asked the person in charge how they were ...

You can't use wildcards in statements like you want. The easiest way for you to do what you want is to just grant the user the db_datareader role and make sure they're not part of a group with the ...