Re: needed privileges for mat views
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Mon, 16 Aug 2010 05:39:03 -0700 (PDT)
Message-ID: <664954f8-b1a2-48ca-98f8-6137d4f25376_at_d8g2000yqf.googlegroups.com>
On Aug 16, 2:27 pm, Andreas Mosmann <mosm..._at_expires-31-08-2010.news- group.org> wrote:
> Andreas Mosmann schrieb am 13.08.2010 in
> <1281706582..._at_user.newsoffice.de>:
>
> Your links solved my problem. I did not expect that a "create table"
> privilege is needed too (and I still do not understand, why).
> But after giving this it worked fine.
>
> Thank you.
> Andreas
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de
Date: Mon, 16 Aug 2010 05:39:03 -0700 (PDT)
Message-ID: <664954f8-b1a2-48ca-98f8-6137d4f25376_at_d8g2000yqf.googlegroups.com>
On Aug 16, 2:27 pm, Andreas Mosmann <mosm..._at_expires-31-08-2010.news- group.org> wrote:
> Andreas Mosmann schrieb am 13.08.2010 in
> <1281706582..._at_user.newsoffice.de>:
>
> Your links solved my problem. I did not expect that a "create table"
> privilege is needed too (and I still do not understand, why).
> But after giving this it worked fine.
>
> Thank you.
> Andreas
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de
"(and I still do not understand, why)."
I think it is because you have to create a SEGMENT for the MW, and it is created on the table owner schema. Thus the owner needs the 'CREATE TABLE' (there is no 'CREATE SEGMENT' right.)
Cheers.
Carlos. Received on Mon Aug 16 2010 - 07:39:03 CDT