URGENT(user creation)

[KVREDDY]

hiiiiii friends I am new Dba ,
I have task ---
1)create 3 users they are

a) Application adminstrator with previlages are update,delete,insert,select and backup of tables

b)super user previlages are update,delete,insert,select and backup of tables

c) normal user previlages are insert and select only

i am using oracle8i on NT.
when ever i am trying to create user i get a error
ORA-01031: insufficient privileges

I am new DBA how to overcome this error help me.
thanks

[ngwh]

fren,

what account did u login to Oracle to create user acct? shld be SYS or INTERNAL

[KVREDDY]

hiiiiii We have somany databases and users,
prsent I am connected to normaluser and password.
But i try to connect as a System/manager as sysdba
I get error ----ORA-12203: TNS:unable to connect to destination
how to create users?

thanking u

[ngwh]

come on u shld know which server u accessing despite the fact that u hv many users...we know..
try :

1) telnet to your desired DB server then
2)sqlplus internal at command prompt
3) start creating ur users!

[reydp]

to create a user:
login as a dba user (or sys, system,internal)
create user USERNAME identified by PASSWORD
default tablespace USERS
temporary tablespace TEMP;
grant create session to USERNAME;


TNS-problem:
if other user can be able to login to the database, then
your tnsnames to your machine is not setup.
find TNSNAMES.ORA in your machine and copy it to your machine in the same directory.

[sanjaygk]

For creating a normal user you can log in as system or sys or internal. Better you do one thing create one user give privilages of dba then always connect that user and do the necessities.
Please give the tnsping < service name>
then check for the tnsnames.ora for the corresponding service if u dont have add the service entry in the client tnsnames.ora . by takeing hostname, service name and port number. u can do that.