Try granting the DBA role to the user.
Thomas Langholen <Thomas.Langholen_at_Q-Free.com> wrote in message
news:7effp3$935$1_at_hurricane.microdesign.no...
> 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:15:19 CDT
