Re: View Creation

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_at_rulegen.com> 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_at_fpl.com>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"
>

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