How do I disallow SELECT * from any table for end users?

I am trying to prevent end users (or at least some of them) from using SELECT * from [table] i.e., I want them to say SELECT X, Y, Z from [table] ....

Is there a way that I can lock this out on the server side i.e., not through the applications (Forms etc...)?

Can I say something like: "if user = dba, then allow else disallow"?

Thanks for any info.
PS. Please respond by email if possible!

-Mir. Received on Mon Feb 03 1997 - 00:00:00 CST