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