Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem with v$views
Dear Pratap,
the owner of a view must own all the tables/views referenced by the view or have a direct grant with the grant option on the non-owned tables/views in order to create a view and grant access to the view. This is probably your problem.
Best regards
roy Received on Tue May 09 2006 - 07:25:47 CDT