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

After "GRANT ..." You must execute:
create public synonym emp for scott.emp; create public synonym dept for scott.dept;

        or
use scott.emp or scott.dept in you select.update or insert statement

Mark Sherwood <marks_at_alphsbusiness.co.uk> ÚÁÐÉÓÁÎÏ × ÓÔÁÔØÀ <34fe9f58.0_at_ispc-news.cableinet.net>...
> 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';
>
>
Received on Fri Mar 06 1998 - 00:00:00 CST