Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: assiging a user to another users tables
Steven,
Ever heard of GRANT? You need to GRANT select, insert
whatever on the tables created by ADM to US1.
then US1 can use the tables. You might also consider creating
synomyns to make references easier.
Becca
> Hi there
> Oracle8 NT4
>
> 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.
>
>
> Thx
> Steven
>
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6341&cus_id=USENET&qtn_id=6284
Received on Mon Oct 25 1999 - 20:58:04 CDT