Home » SQL & PL/SQL » SQL & PL/SQL » create user
create user [message #36] Sat, 05 January 2002 21:19 Go to next message
Messages: 4
Registered: January 2002
Junior Member
i'm currently a student in a uni in malaysia.
we were given an account in oralce to implement our assignment.
we had created 10 table for a database .
how could we create user that could use our database?.
we should have 3 level view - customer, worker and programmer,
and every level has differrent privilages.
i''d try create user..but an error occur saying that

SQL> create user joe identified by mypasswd;
create user joe identified by mypasswd
ERROR at line 1:
ORA-01031: insufficient privileges
what is the problem?
i wish that u could give some idea..
thank you
Re: create user [message #37 is a reply to message #36] Sun, 06 January 2002 03:03 Go to previous messageGo to next message
Messages: 417
Registered: September 1998
Senior Member
To be able to create a new users you need some specific privileges.

Either ask your DBA to grant you this privileges
or ask him to create these 3 users.
Re: create user [message #40 is a reply to message #36] Sun, 06 January 2002 16:31 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
you need create user privilege to create user account
Previous Topic: converting oracle datatypes to and from RAW
Next Topic: use DCL commands in pl/sql
Goto Forum:

Current Time: Sat May 25 15:50:26 CDT 2024