I didn't have any success with Adam Haines' approach. When trying to test this I got the error:

[font="Courier New"]The specified schema name "dbo" either does not exist or you do not have permission to use it.

[/font]

I think Lowell had a reply here for the convoluted way to make it work:

http://www.sqlservercentral.com/Forums/Topic1241211-391-1.aspx

It's not my first preference. I'd rather create a view and then let a group go to town on it. It's more obvious that way.