Re: Help: How to make table available to other users

From: Mark Cudmore <mcudmore_at_kamloops.env.gov.bc.ca>
Date: 1998/03/04
Message-ID: <1998Mar4.122415.9975@vmsmail.gov.bc.ca>#1/1

First of all you have to grant select, insert, update, delete on the tables

GRANT SELECT, UPDATE, DELETE, INSERT ON EMP, DEPT TO 'user name or role';

Mark Sherwood wrote in message <34fda908.0_at_ispc-news.cableinet.net>...
>I have not used Oracle 7 for a year and I have forgotten how to allow other
>users to be able to see a table.
>I am using personal oracle 7.3.2.2.1 and PL/SQL 2.3.2.2.0 and I am trying
to
>allow other users access to the emp and dept tables which currently only
the
>user scott can access.
>Does the user have to be created in SQL instead of in oracle navigator?
>
>Mark :-(
>
>
Received on Wed Mar 04 1998 - 00:00:00 CST