Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: assiging a user to another user's tables
> 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