Lee Is there anything in the alert log? As you may know, ORA-3113 has been a symptom of countless bugs over time (especially with views, I recall); armed with more info you might be able to construct a more useful Metalink query. Regards Nigel 2009/2/11 Robertson Lee - lerobe <Lee.Robertson@xxxxxxxxxx> > > grant select on <view_name> to <user> > > Error at line 1 > > ORA-03113: end-of-file on communication channel > >