Re: Synonyms and Oracle permissions

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 3 Nov 2006 06:27:44 -0800
Message-ID: <1162564064.443823.108590@h54g2000cwb.googlegroups.com>

On Nov 3, 1:56 pm, jpato..._at_iki.fi wrote:
> Greetings,
>
> Frank van Bortel wrote:
> > jpato..._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

One by one, for the obvious security reasons. Do not grant anything you do not need to grant (in that light, better replace "all" by "select" in my previous post) Received on Fri Nov 03 2006 - 08:27:44 CST