Re: SQL Plus connection problem

From: Reid Lai <reidlai_at_hk.super.net>
Date: Mon, 02 Nov 1998 23:20:53 +0800
Message-ID: <363DCDD5.EBEC7095@hk.super.net>

Have your Oracle user been granted CREATE SESSION system privilege?

Low Heng Sin wrote:

> we are running oracle 7.3.3 on Windows NT 4.0. Start from a couple of weeks
> ago, we have problems making connection to oracle from sqlplus. The weird
> thing is we can only connect using system login and not other user but we
> can make any connection to the oracle server using other tools
> (powerbuilder, oracle enterprise manager, etc). The Sqlplus session would
> just hang when we try to connect using login other than the system login.
> Any one out there can help me solve this problem ? thanks.

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Mon Nov 02 1998 - 09:20:53 CST