Re: assiging a user to another user's tables

User ADM has to grant SELECT privilege on his tables to US1:

grant select on <table> to us1;

To give write privileges, he has to grant INSERT, UPDATE and/or DELETE privilege:

grant insert, update, delete on <table> to us1;

User US1 has to access ADM tables with the owner name:

select * from ADM.<table>;

If you don't want us1 knows the owner name or if you don't want your code depends on the owner name, you have to create a public synonym:

create public synonym <table> for adm.<table>;

then US1 can access to the table with

select * from <table>;

--
Have a nice day
Michel

Steven Egberghs <steven.egberghs_at_eni.be> a écrit dans le message : 380D90FA.F44C1A80_at_eni.be...
> 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
>
Received on Wed Oct 20 1999 - 05:11:05 CDT