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