Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem with v$views

Re: problem with v$views

From: roy <roy.schultheiss_at_t-online.de>
Date: 9 May 2006 05:25:47 -0700
Message-ID: <1147177547.653219.113920@i39g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US