Re: Synonyms and Oracle permissions

From: Robbert van der Hoorn <reply_at_forum.only>
Date: Fri, 3 Nov 2006 22:18:30 +0100
Message-ID: <454bb223$0$334$e4fe514c@news.xs4all.nl>

<jpatokal_at_iki.fi> schreef in bericht
news:1162558606.256614.257940_at_b28g2000cwb.googlegroups.com...
> Greetings,
>
> Frank van Bortel wrote:
>> jpatokal_at_iki.fi schreef:
>> > So how do I grant USER access to all of OWNER's objects? In case it
>> > matters, this is Oracle 10.2.0.2.
>>
>> grant all on <table_name> to user;
>
> Thanks for the fast reply! That was so obvious that I stupidly assumed
> it wouldn't work
> on synonyms, but evidently it does (d'oh). Is there any easy way to
> grant USER access
> to everything owned by OWNER, or do I need to do it one by one?

There is: tell USER the password of OWNER ;-)

>
> Cheers,
> -jani
>
Received on Fri Nov 03 2006 - 15:18:30 CST