Re: Help: How to make table available to other users
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1998/03/04
Message-ID: <34FDAEE0.E9BA2E9D_at_charlie.cns.iit.edu>#1/1
Date: 1998/03/04
Message-ID: <34FDAEE0.E9BA2E9D_at_charlie.cns.iit.edu>#1/1
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.Received on Wed Mar 04 1998 - 00:00:00 CET