and in addition the CREATE VIEW privilege. On Tue, Oct 28, 2008 at 8:47 PM, Toon Koppelaars <toon@xxxxxxxxxxx> wrote: > She needs the select object privilege granted directly from the other > schema to her schema. > I.e. not via a role. > > > On Tue, Oct 28, 2008 at 9:30 PM, SHEEHAN, JEREMY > <JEREMY.SHEEHAN@xxxxxxx>wrote: > >> I've got a question in View creation and I think it has to do with >> permissions on the base tables. >> >> >> >> I've got a user who is trying to create a view on another user's schema, >> but is unable to. She can select on the tables with no problem, but when >> she goes to create the view she gets an 'insufficient privileges' error. >> Does she need select with admin option on the tables in question? >> >> >> >> Thanks guru's! >> >> >> >> Jeremy >> >> >> > > > > -- > +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- > Toon Koppelaars > RuleGen BV > +31-615907269 > toon_at_rulegen_dot_com > www_dot_rulegen_dot_com > > Author: "Applied Mathematics for Database Professionals" > -- Niall Litchfield Oracle DBA http://www.orawin.info