Re: How does one permit access tables to different users ?

In <4SEP95.05274305_at_tifrvax.tifr.res.in> patnaik_at_tifrvax.tifr.res.in writes:
>
>
>How does one permit access to Oracle user A's tables to Oracle user B.
>
 LOGIN AS USER A (SQLPLUS) AND EXECUTE THIS COMMAND  SQL > GRANT ALL (SELECT, INSERT, UPDATE, DELETE) ON TABLE1 TO B;  YOU CAN GRANT ALL OR SELECT ONE OF THE OPTIONS IN THE BRACKET.  THEN LOGIN AS USER B (SQLPLUS) AND CREATE SYNONYMS.  SQL > CREATE SYNONYM TABLE1 FORM A.TABLE1;  HENCE WHEN YOU EXECUTE DESC TABLE1 AS USER B YOU WILL BE ABLE TO SEE THE TABLE HOPE THIS HELPS SWAPAN JHA
CONSULTANT
JHAS_at_IX.NETCOM.COM Received on Mon Sep 04 1995 - 00:00:00 CEST