Re: Problem granting permissions

Your problem is not that SYSTEM owns the view, but rather who owns the underlying tables of the view? The "insufficient privs" error is most likely coming from the fact that the person querying the view does not have sufficient privs on the underlying tables. Sign on as the owner of the underlying tables and grant privs directly to the user.

HTH,
Brian

pixelmeow wrote:
>
> Hello, all;
>
> I apologize if this is the second post on this, I posted last night
> and don't see it here today.
>
> I'm trying to grant permissions on SYSTEM.FRM45_ENABLED_ROLES to users
> in the database, but am getting "insufficient privileges" error
> (logged on as SYSTEM). Does this mean that even though the view is
> under SYSTEM, some other entity "owns" it?
>
> Oracle 8.1.5.0.0, win2kpro.
>
> I've looked and looked, but I can't find answers on this; thanks very
> much for your help.
>
> --
> Teresa Redmond
> Programmer/Analyst II
> Anteon Corporation
> tredmond at anteon dot com

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"