Hugo Kornelis (7/3/2012)
It's a bit disappointing that nobody has yet commented that the "best" way to deal with the issue is to drop the view, then create a new one that does not use SELECT * but spells out the relevant columns. 😀Nice question, Steve. Thanks!
Would not an ALTER VIEW with a proper column list also suffice? No need to reassign permissions afterwards too.
A few people's posts have implicitly said they'd do a column list in place of SELECT * 😀