OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » create user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create user [message #36]

Sat, 05 January 2002 21:19

diana365
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

Report message to a moderator

Re: create user [message #37 is a reply to message #36]

Sun, 06 January 2002 03:03

Mike
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.

Report message to a moderator

Re: create user [message #40 is a reply to message #36]

Sun, 06 January 2002 16:31

Suresh Vemulapalli
Messages: 624
Registered: August 2000

Senior Member

you need create user privilege to create user account

Report message to a moderator

Previous Topic:	converting oracle datatypes to and from RAW
Next Topic:	use DCL commands in pl/sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jun 25 14:31:10 CDT 2025