Field Exclusion

[gtrfreak]

I want to select all but certain fields. We are exporting data to different clients and we know what we don't want them to have, but what we want them to have may very from client to client.

Thanks

 

[carp]

I think you will have to create a separate view for each customer that has a different set of columns available to them. Then grant SELECT on the view instead of the table.