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

Hi,

I think you forgot to create a synonym for the table also.

Either you let scott fire this one:

CREATE PUBLIC SYNONYM EMP FOR EMP; or you let user xx fire this one:

CREATE SYNONYM EMP FOR SCOT.EMP; Michael Ringbo, mri_at_dde.dk

Mark Sherwood wrote:

> I have tried using the following grant statement but the user still
> can not
> see table. Even the sys and system users can not see the emp and dept
> tables.
> The error message "Object does not exist." is displayed when trying
> the
> command "desc emp"
>
> **********
>
> 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 Thu Mar 05 1998 - 00:00:00 CET