RE: View Creation

From: SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>
Date: Tue, 28 Oct 2008 16:30:41 -0400
Message-ID: <6CA0BC4E977BD546A58B47511C5966A601DDBD8BC5@JBXEXVS02.fplu.fpl.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 28 2008 - 15:30:41 CDT

This message: [ Message body ]
Next message: Steve Adams: "Re: Chained vs. migrated rows - Any easy way to tell the difference?"
Previous message: Roman Podshivalov: "Re: shared storage solution"
In reply to: Roman Podshivalov: "Re: shared storage solution"
Next in thread: Toon Koppelaars: "Re: View Creation"
Reply: Toon Koppelaars: "Re: View Creation"
Maybe reply: Bort, Guillermo: "RE: View Creation"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message