the "with grant option" would be needed if the user who created the View now wants to grant privileges on the view to another user. Bradd Piontek "Next to doing a good job yourself, the greatest joy is in having someone else do a first-class job under your direction." -- William Feather On Tue, Oct 28, 2008 at 3: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" >