Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Synonyms and Oracle permissions

Re: Synonyms and Oracle permissions

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: 3 Nov 2006 04:50:51 -0800
Message-ID: <1162558251.263663.168540@m7g2000cwm.googlegroups.com>

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;

which is documented, of course, at http://tahiti.oracle.com Received on Fri Nov 03 2006 - 06:50:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US