I figured that was the only way to do it. Thanks, Sidney! Jeremy From: Sidney Chen [mailto:huanshengchen@xxxxxxxxx] Sent: Monday, October 24, 2011 10:43 PM To: Sheehan, Jeremy Cc: oracle-l-freelists Subject: Re: mv refresh question I choose to wrap the refresh in a procedure, then grant execute on the procedure to specific users. -- Regards Sidney Chen -- //www.freelists.org/webpage/oracle-l