Re: ORA-12224 and ORA-01031

Hi Thomas,

This is a simple way:
Connect to SQL*Plus with the internal account and do the following statements:

drop user thomas;
create user thomas identified by thomas; grant connect to thomas;
grant resource to thomas;

Now you have created a user thomas with the password thomas. You allow thomas to connect to the database. You allow thomas to create objects (resource).

Regards,
Gudrun

Thomas Langholen wrote:

> Hello all
>
> I have used the Oracle DataBase Assistant to create a data base, then I
> created a user. My problem is that I have no Idee what I shall grant the
> user so he can make tables using CREATE TABLE xxx (this is where I get the
> ORA-01031: insufficient privileges error)
>
> Also if I try to connect to the data base using user xxxx pass xxxx
> hoststring ORCL from SQL *Pluss I get the ORA-12224: TNS:no listener error.
> The Listner is running (OracleTNSListner80 Started Automatic, from
> services, Control Panel)
>
> I can access the data base from both INTERNAL and the user from svrmgr in
> dos.
>
> I am using Oracle server 8 under NT 4 SP 4.
>
> Please help me because I am lost here.
>
> Thomas Langholen
> Q-Free(r) Norway
Received on Wed Apr 07 1999 - 07:31:43 CDT