How can I grant "deny access" to all but 4 tables in a schema?

**Ana Weaver** · Mar 30 '11, 09:51 PM

I have a user that I only want to grant select on 4 tables that are used for his view in his schema. I want to deny him access to all other objects on that schema. Is there a quick way to script this so I don't have to manually specify each table/view etc.? This user is going to make a call to the database directly on the backend, so I can't put security on the GUI.

Any advice would be greatly appreciated.
Ana