Re: privileg problem

From: Andreas Mosmann <mosmann_at_expires-31-08-2011.news-group.org>
Date: Fri, 19 Aug 2011 10:21:40 +0200
Message-ID: <1313742100.34_at_user.newsoffice.de>

Carlos schrieb am 19.08.2011 in
<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; this was the right hint. Without Grant Option I can not create a view, even if I can execute the select- statement itself. I granted "select any table with grant option" and it works fine.

> HTH.
yes, it did :)

> btw:
>>> " I can *select* rows from a user"
> This does not sound like Oracle terminology... ;-)

what is the oracle terminology in this case?

> Cheers.

> Carlos.
Thank you
Andreas

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de

Received on Fri Aug 19 2011 - 03:21:40 CDT