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

All tables are when created have a defined owner. If the Scott user creates a table called EMP, then oracle stores that table as SCOTT.EMP. You have to qualify the owner/creater of the table with creating a synomyn or granting rights to that table.

Antonio
Solar Software, Inc

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