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: assiging a user to another user's tables

Re: assiging a user to another user's tables

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Wed, 20 Oct 1999 12:14:05 +0200
Message-ID: <380da083_1@news2.prserv.net>


> I have a user 'ADM' with create table-rights.
> A second user 'US1' has only connect-rights.
>
> How can I setup Oracle, so that when I connect as US1, I see the ADM's
> tables.
>

Create public or private synonym. And grant the table rights to the new user Regards
Nicolas Bronke Received on Wed Oct 20 1999 - 05:14:05 CDT

Original text of this message

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