mysqldump of a database by a user with columnar priveleges

Is there a way to ignore certain fields 开发者_JAVA百科of a table using mysqldump without creating a view?

Not with mysqldump. You probably want to use SELECT ... INTO OUTFILE instead. See http://dev.mysql.com/doc/refman/5.1/en/select.html

(and then you can use LOAD INFILE to restore it: http://dev.mysql.com/doc/refman/5.1/en/load-data.html)