Re: managing schemas

Hi

You must grant some priviledges (select,delete,insert,update) to the second user.
For instance:

grant select on sales.myTable to user2;

Kari

(Mr.) Kari Pannila

      Oracle DBA

-- 

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.


Patrick Joyal wrote:


> 

> Hi,

> 

> I've created two users, Production and Sales.  Each users created their own

> tables and procedures etc...

> 

> But now I want the first user access the tables created by the second users.

> I know I can create synonyms, but it don't seem to work.  I can't even

> access tables by using the schema, like

> 

>  select * from sales.myTable

> 

> any help would be appreciated.

> 

> thanks

> 

> Patrick