Re: privileg problem

From: Carlos <miotromailcarlos_at_netscape.net>
Date: Thu, 18 Aug 2011 23:46:25 -0700 (PDT)
Message-ID: <71848b9e-ef97-4b22-bf03-8dc917764bd2_at_fv14g2000vbb.googlegroups.com>

On Aug 18, 11:02 pm, Andreas Mosmann <mosm..._at_expires-31-08-2011.news- group.org> wrote:
> Hi,
>
> I have a problem with privileges.
>
> I can *select* rows from a user
>
> select   BlaBla, BlaBlub
> from  OtherUser.Table
>
> I can *not* *create* *a* *view* from the same select
> (ORA-01031: Unzureichende Berechtigungen)
>
> create view MyBlaBla as
> select   BlaBla, BlaBlub
> from  OtherUser.Table
>
> I can *create* *a* *table* from the same select
> create table MyBlaBla as
> select   BlaBla, BlaBlub
> from  OtherUser.Table
>
> I can create views, tables and so on on any selects to tables of other
> users on remote databases, but not on the same db (no prob to select,
> but to create view)
>
> I have the privilegs
> "SELECT ANY TABLE", "CREATE ANY VIEW"
> Why I can not create the view? What privileg is needed for this? Do I
> really have to use object privilegs?
>
> Thanks in advance
> Andreas
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de

GRANT SELECT ON *** TO *** WITH GRANT OPTION; HTH. btw:
>>" I can *select* rows from a user"

This does not sound like Oracle terminology... ;-)

Cheers.

Carlos. Received on Fri Aug 19 2011 - 01:46:25 CDT