privileg problem

From: Andreas Mosmann <mosmann_at_expires-31-08-2011.news-group.org>
Date: Thu, 18 Aug 2011 23:02:20 +0200
Message-ID: <1313701340.96_at_user.newsoffice.de>



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
Received on Thu Aug 18 2011 - 16:02:20 CDT

Original text of this message