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

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