Re: Synonyms and Oracle permissions

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?

Cheers,
-jani Received on Fri Nov 03 2006 - 06:56:46 CST