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

Hi
Give them GRANT privilages (SELECT,INSERT,UPDATE, DELETE)

GRANT SELECT,INSERT ON EMP TO X; AMARENDRA Mark Sherwood wrote:

> 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 :-(

--
*****************************************************************
AMARENDRA B NETTEM
Oracle Certified DBA (OCP)
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.

Residence:
-----------
5039 N E River Road,
Apt. 1A
NORRIDGE, IL 60656


Ph.No. (708) 583 9870 (H)
       (312) 913 6758 (W)

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************
Opinions are mine and do not necessarily reflect those
of Whittman-hart Inc.